select id,description from my_table order by description;
select id,description from my_table order by convert_to(description,‘GBK’);
第一种是按照LANG=C,即ASCII,进行排序。 第二种是按照拼音排序。
select id,description from my_table order by description;
select id,description from my_table order by convert_to(description,‘GBK’);
第一种是按照LANG=C,即ASCII,进行排序。 第二种是按照拼音排序。