MySQL汉字字段排序需要进行一下转换,以下是示例代码:
select areaName from area order by convert(areaName USING gbk) COLLATE gbk_chinese_ci asc
说明:areaName为列名area为表名