UTF8 默认校对集是 utf8_general_ci , 它不是按照中文来的。你需要强制让MySQL按中文来排序。select * from core_vender_info order by convert(vender_abbrev USING gbk) COLLATE gbk_chinese_ci
select * from core_vender_info order by convert(vender_abbrev USING gbk) COLLATE gbk_chinese_ci =========================================== 确实是这样的,收藏了
===========================================
确实是这样的,收藏了