The MySQL database is implemented to sort Chinese text fields alphabetically by first letter

1. In MySQL, we often sort a field query, but in Chinese sorting and search, the Chinese character sorting and search results are often wrong. This situation is present in many versions of MySQL.

If this problem is not resolved, then MySQL will not be able to actually handle Chinese. This problem occurs because MySQL is case insensitive when querying strings, and when Yi MySQL is generally used as the default character set for the ISO-8859 character set, this behavior is caused by the Chinese encoding character-case conversion during comparison.

2. Workaround:
For fields that contain Chinese, add the "binary" attribute to the binary comparison, for example, "name char (10)" to "name Char (TEN) binary".
If you compile MySQL using the source code, you can compile MySQL using the –WITH–CHARSET=GBK parameter, so that MySQL will directly support the Chinese search and sort (default is Latin1). You can also use EXTRA-CHARSETS=GB2312,GBK to add multiple character sets.

3. If you do not want to modify the table structure or recompile MySQL, you can also use the CONVERT function in the order by section of the query statement.

For example, select * FROM MyTable ORDER by CONVERT (Chinesecolumnname USING GBK);
UTF8 default Proofing set is Utf8_general_ci, it is not in Chinese. You need to force MySQL to sort by Chinese.

For example:

SELECT distinct (province_name) from Bw_store ORDER by convert (Province_name using GBK) ASC

The MySQL database is implemented to sort Chinese text fields alphabetically by first letter