Mysql fields are sorted by pinyin

MySQL uses the default Character Set of latin1. That is to say, the Chinese character fields are stored directly using the GBK internal code encoding, if you want to sort the fields with Chinese characters in pinyin (especially those with names), the order by keyword cannot be used by default.
After searching on the Internet, most of the methods on the Internet are for databases that use the utf8 character set. The main methods are as follows:
Directly CONVERT the field to gbk, for example: www.2cto.com SELECT * FROM table order by convert (chinese_field USING gbk );
Or simply change the corresponding field to the gbk character set. Iloveyin