Sort text fields in MySQL

Method 1) SELECT * FROM MyTable ORDER by CONVERT (Chinesecolumnname USING GBK); (Note: Chinesecolumnname bit sort field)

Method 2) Add the "binary" attribute to the field containing the Chinese as a binary comparison, for example, change "name char (10)" to "name Char (TEN) binary".

Reason:

In MySQL, the sorting and finding results of Chinese characters are wrong when sorting and searching in the same language. 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.

Sort text fields in MySQL