1.数据库字符集utf-8
select * from user WHERE 1=1 order by CONVERT( user_name USING gbk ) COLLATE gbk_chinese_ci ASC
先将user_name字段的值转换为gbk,然后按照 gbk_chinese_ci 规则进行排序
gbk_chinese_ci 规则结果
优先null,然后到数字,最后才是汉字按照字母排序
2.数据库字符编码latin1
select * from user order by birary(user_name) asc ;