MySQL sorted by Kanji Phonetic Alphabet

If the MySQL encoding format is the GBK character set, you can add it directly after the query statement

Order by name ASC;  --Sort in ascending order

if it is a UTF8 character set, you need to transcode the field when sorting,

ORDER by CONVERT (name using GBK) ASC;

attached: View MySQL encoding method

SHOW VARIABLES like ' character% ';

Character_set_client is the client-side encoding method;

Character_set_connection the encoding used to establish the connection;

Coding of character_set_database database;

Character_set_results the encoding of the result set;

Character_set_server the encoding of the database server;

Itmyhome

MySQL sorted by Kanji Phonetic Alphabet