select areaName from area order by convert(areaName USING gbk) COLLATE gbk_chinese_ci ascspa
说明：areaName为列名.net
area为表名blog
文章来自：http://blog.csdn.net/lpz283929516/article/details/8206851ci