品牌列表,按字母排序,开发一个app接口:表的默认字符集utf8mb4,核对utf8mb4_general_ci
解决方案:
select * from carBrand WHERE 1=1 order by CONVERT( carBrandName USING gbk ) COLLATE gbk_chinese_ci ASC
品牌列表,按字母排序,开发一个app接口:表的默认字符集utf8mb4,核对utf8mb4_general_ci
解决方案:
select * from carBrand WHERE 1=1 order by CONVERT( carBrandName USING gbk ) COLLATE gbk_chinese_ci ASC