I. Method 1
In MySQL, the sorting and searching of Chinese characters are wrong when they are sorted and searched. 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: MySQL in the query string is not sensitive to the case, when compiling the MySQL in general with the ISO-8859 character set as the default character set, so in the comparison process in the Chinese character case conversion caused this phenomenon, a solution is to include the Chinese field plus " Binary property to make it a binary comparison, such as changing "name char (10)" to "name char" binary.
Two. Method 2
If you use the source code to compile MySQL, you can compile MySQL using the--WITH--CHARSET=GBK parameters, so that MySQL will directly support Chinese search and sorting.