SELECT * FROM shop WHERE id=3 ORDER BY CONVERT( nameUSING gbk ) COLLATE gbk_chinese_ci ASC
关键是 ORDER BY CONVERT( nameUSING gbk ) COLLATE gbk_chinese_ci ASC
CONVERT( nameUSING gbk ) 转换编码 然后排序
SELECT * FROM shop WHERE id=3 ORDER BY CONVERT( nameUSING gbk ) COLLATE gbk_chinese_ci ASC
关键是 ORDER BY CONVERT( nameUSING gbk ) COLLATE gbk_chinese_ci ASC
CONVERT( nameUSING gbk ) 转换编码 然后排序