Let Mysql support the implementation of Chinese sorting _mysql

Let MySQL support Chinese sort

When compiling MySQL, it is generally used as the default character set by the ISO-8859 character set, so in the comparison, the character case conversion of Chinese encoded characters causes this phenomenon, one solution is to add the "binary" attribute to the field containing Chinese as a binary comparison,
For example, change "name char (10)" to "name char" binary.
Use the--WITH--CHARSET=GBK parameter when compiling MySQL so that MySQL will directly support Chinese lookup and sorting.

MySQL ORDER by Chinese

In MySQL, we often sort a query on a field, but in the Chinese sorting and search, the Chinese character sorting and search results are often wrong. This situation exists in many versions of MySQL.
If this problem is not resolved, then MySQL will not be able to actually handle Chinese. The reason for this problem is that MySQL is case-insensitive when querying strings, and when it comes to MySQL, the ISO-8859 character set is used as the default character set, so it is caused by the case conversion of Chinese encoded characters in the comparison process.
Workaround:
Add the "binary" property to the field containing Chinese as a binary comparison, such as changing "name char (10)" to "name char" binary.
If you use the source code to compile MySQL, you can compile MySQL using the--WITH--CHARSET=GBK parameter, so MySQL will directly support Chinese lookup and sorting (the default is Latin1). You can also use EXTRA-CHARSETS=GB2312,GBK to add multiple character sets.
If you do not want to modify the table structure or recompile MySQL, you can also use the CONVERT function in the order by part of the query statement. For example, select * FROM MyTable ORDER by CONVERT (Chinesecolumnname USING GBK);

UTF8 The default proofing set is Utf8_general_ci, which is not in Chinese. You need to force MySQL to sort by Chinese.

SELECT * from Core_vender_info ORDER by convert (Vender_abbrev USING gbk) COLLATE gbk_chinese_ci