Mysql Chinese sorting considerations and implementation Methods _mysql

MySQL Chinese Sort Method 1
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 of Chinese character encoding characters in the case conversion caused this phenomenon, the more urgent way is to include the Chinese field plus the "binary" attribute, To make it a binary comparison,
For example, change "name char (10)" to "name char" binary "."
(Has been successfully tested)

MySQL Chinese Sort Method 2
Use--WITH--CHARSET=GBK when compiling MySQL
(not tested)