编码是utf8_general_ci SELECT name FROM `表` ORDER BY CONVERT( name USING gbk ) COLLATE gbk_chinese_ci ASC