select areaName from area order by convert(areaName USING gbk) COLLATE gbk_chinese_ci asc说明:areaName为列名area为表名