Considerations and implementation methods for sorting MySQL Chinese Characters

MySQL Chinese sorting method 1
MySQL is case-insensitive when querying strings. In programming MySQL, The ISO-8859 character set is generally used as the default character set. Therefore, the case-sensitive conversion of Chinese encoding Characters During the comparison process is caused, the emergency response method is to add the "binary" attribute to fields that contain Chinese characters for Binary comparison,
For example, change "name char (10)" to "name char (10) binary "."
(Tested successfully)

MySQL Chinese sorting method 2
Use -- with -- charset = GBK when compiling MySQL
(Not tested)