如果數(shù)據(jù)表tbl的某字段name的字符編碼是latin1_swedish_ci;
select * from `tbl` order by birary(name) asc

如果數(shù)據(jù)表tbl的某字段name的字符編碼是utf8_general_ci;
SELECT name FROM `tbl` WHERE 1
ORDER BY CONVERT( name USING gbk ) COLLATE gbk_chinese_ci ASC