MYSQL is sorted by UTF8 Chinese characters (pinyin)

This article introduces how to sort Chinese characters and Chinese characters by pinyin in mysql. For more information, see.

The order by keyword is used to sort the data in the record set.

If we use a normal sorting method

The Code is as follows:	Copy code
SELECT * FROM Persons order by age

This is impossible for Chinese.

If you want to sort Chinese characters, we can:

The Code is as follows:	Copy code
Select * from goods order by CONVERT (title using gbk) asc.