mysql中汉字排序无效解决方案

select * from table
order by convert(first_name using gb2312) asc