MySQL to achieve Chinese phonetic sorting

MySQL creates a new table, by default with the UTF8 character set, Chinese cannot be directly sorted by pinyin.

For example, the following statement:

SELECT *  from ' Tb_fixedassets ' Order  by C_faname

The results obtained are

Workaround: Change the character set of the field you want to sort to GBK, without changing the character set of the entire database. The results of the modified query are as follows:

MySQL to achieve Chinese phonetic sorting