A simple example of MySQL sorting Chinese Characters in pinyin; mysql sorting in pinyin

A simple example of MySQL sorting Chinese Characters in pinyin; mysql sorting in pinyin

If the field storing the name uses the GBK character set, it is easy to do, because the GBK internal code encoding itself uses the pinyin sorting method (3755 first-level Chinese characters are commonly used in pinyin sorting, second-level Chinese characters are not enough, but considering that names and so on are commonly used Chinese characters, it is enough to sort the first-level Chinese characters correctly ).

Add order by name asc directly after the query statement. The query results are sorted in ascending order based on the last name;

If the field storing the name uses the utf8 character set, the field needs to be transcoded during sorting; the Code is order by convert (name using gbk) asc; similarly, the query results are also sorted in ascending order of surnames;

The above MySQL sorting by Chinese characters is a simple example of all the content shared by xiaobian. I hope to give you a reference, and I hope you can provide more support for the help house.