MySQL is sorted by Chinese characters and Pinyin letters, and mysql is sorted by Chinese Characters

MySQL is sorted by Chinese characters and Pinyin letters, and mysql is sorted by Chinese Characters

If the MySQL encoding format is GBK character set, you can add

Order by name asc; -- sort in ascending order

If the utf8 character set is used, fields must be transcoded during sorting,

Order by convert (name using gbk) asc;

Appendix: view the MySQL encoding method

Show variables like 'character % ';

Character_set_client is the client encoding method;

Character_set_connection indicates the encoding used to establish a connection;

Character_set_database database encoding;

Character_set_results result set encoding;

Character_set_server database server code;

Author: itmyhome