MySQL sorting Chinese details and examples

Detailed explanation of MySQL sorting Chinese characters

By default, MySQL only supports sorting of dates, times, and English strings. If you use order by on Chinese characters, you may not get the desired results. For example, the following query will not sort by the pinyin of Chinese characters as we want:

SELECT * from user order by user_name;

If you want to sort relative to Chinese, you can use CONVERT (coloum_name USING GBK) to convert Chinese to GBK encoding, and then sort, you can sort according to the pinyin of Chinese:

SELECT * from user order by CONVERT(user_name USING GBK);

Thank you for reading, I hope it can help you, thank you for your support of this site!