Mysql Chinese sorted by alphabet SQL

In mysql, we use order by id and the like most. This is generally a numerical sorting. If we want to sort Chinese in mysql, how should we write it, the following describes how to sort Chinese Characters in alphabetical order.

Method Statement of Chinese sorting

The Code is as follows:	Copy code
Order by CONVERT (name USING gbk) COLLATE gbk_chinese_ci ASC

MySQL CONVERT () provides a method to CONVERT data between different character sets.

Syntax:

CONVERT (expr USING transcoding_name)

In MySQL, the conversion code name is the same as the corresponding Character Set Name.