select id,description from my_table order by description;

select id,description from my_table order by convert_to(description, ‘GBK’);

第一种是按照LANG=C，即ASCII，进行排序。
第二种是按照拼音排序。