如果数据表team的某字段name的字符编码是utf8_general_ci;
SELECT * FROM `team` WHERE 1 ORDER BY CONVERT( name USING gbk ) COLLATE gbk_chinese_ci ASC
如果数据表team的某字段name的字符编码是latin1_swedish_ci;
SELECT * FROM `team` WHERE 1 ORDER BY BIRARY(name) ASC
技术分享/生活感悟
如果数据表team的某字段name的字符编码是utf8_general_ci;
SELECT * FROM `team` WHERE 1 ORDER BY CONVERT( name USING gbk ) COLLATE gbk_chinese_ci ASC
如果数据表team的某字段name的字符编码是latin1_swedish_ci;
SELECT * FROM `team` WHERE 1 ORDER BY BIRARY(name) ASC