1.修改数据库字符集,把utf-8改为gbk。
2.修改sql语句:把select * from user order by name desc 改为 select * from user order by convert(name using gbk) desc
1.修改数据库字符集,把utf-8改为gbk。
2.修改sql语句:把select * from user order by name desc 改为 select * from user order by convert(name using gbk) desc