mysql 按汉字排序

select  sys_code as code,code_desc as codedesc   from scdp_code where code_type='PROBLEM_CHILD' ORDER BY convert(sys_code using gbk) asc

将 要排序 的列转为 GBK格式  convert(sys_code using gbk)