MySQL simple example of sorting Chinese characters by pinyin

If the field storing the name uses the GBK character set, then it will be easy to deal with, because the GBK internal code itself uses the pinyin sorting method when encoding (the 3755 commonly used first-level Chinese characters are sorted by pinyin, while the second-level Chinese characters are not, but considering that people's names are commonly used Chinese characters, it is sufficient to just sort the first-level Chinese characters correctly).

Directly add order by name asc after the query statement; the query results are sorted in ascending order by last name;

If the field storing the name uses the utf8 character set, the field needs to be converted when sorting; the code is order by convert(name using gbk) asc; Similarly, the query results are sorted in ascending order by last name;

The above simple example of MySQL sorting according to the pinyin of Chinese characters is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.