如果数据表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
2013-6-6 liyangweb.com 李杨 MySQL
如果数据表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
标签: 中文排序SQL
liyangweb.com 李杨
.:.:.:.:.:.:.:.
一个用着普通人不理解的语法和符号,与某个世界的自然法则相沟通,进而实现人类需要的奇迹的人,相当于远古时代的 巫师 ……
2016-11-17 23:44
2016-06-25 17:05
2016-02-11 23:24
2015-07-02 12:29
2015-04-16 23:13
发表评论: