TEST表:
id,name
1,'南山'
思路:吧name中的中文转换为gbk编码排序
SELECT * FROM TEST ORDER BY convert_to(NAME,'GBK')
TEST表:
id,name
1,'南山'
思路:吧name中的中文转换为gbk编码排序
SELECT * FROM TEST ORDER BY convert_to(NAME,'GBK')
转载于:https://my.oschina.net/wangzhaoyu/blog/681063