MySQL sort by pinyin of Chinese characters (turn)

According to the phonetic sorting of Chinese characters, the comparison is more in the sort of the name, according to the phonetic Alphabet of the surname, from A to Z sort;

If the name of the field is stored in the GBK character set, that would be good, because the GBK code encoding itself using the phonetic sorting method (commonly used first-class Chinese characters 3,755 Pinyin sorting, two-level Chinese characters are not, but considering the names of people are commonly used Chinese characters, Therefore, it is sufficient 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 of last name;

If the field that stores the name is in the UTF8 character set, you need to transcode the field at sort time; for the code is Order by convert (name using GBK) ASC; Similarly, the results of the query are sorted in ascending order of the last name;

MySQL sort by pinyin of Chinese characters (turn)