select * from ac_operator order by CONVERT( username USING gbk ) 语句改为 ORDER BY convert_gbk(productname) 即可,不需要再后面的 using gbk 了