字符集为utf-8,其他的自己领悟: select XingMing from YuanGong order by CONVERT(XingMing USING gbk) COLLATE gbk_chinese_ci ASC