1 . 提供一个中文字段按拼音排序的方法:
select empname from tab_name order by nlssort(empname,'nls_sort=schinese_pinyin_m');
对中文字段还可以按偏旁部首和笔画排序:
按偏旁部首:
select empname from tab_name order by nlssort(empname,'nls_sort=schinese_radical_m');
按笔画:
select empname from tab_name order by nlssort(empname,'nls_sort=schinese_stroke_m');
select empname from tab_name order by nlssort(empname,'nls_sort=schinese_pinyin_m');
对中文字段还可以按偏旁部首和笔画排序:
按偏旁部首:
select empname from tab_name order by nlssort(empname,'nls_sort=schinese_radical_m');
按笔画:
select empname from tab_name order by nlssort(empname,'nls_sort=schinese_stroke_m');
其中,emname是字段名。
2 . 按笔画多少排序
select * from test
ORDER BY xm COLLATE Chinese_PRC_Stroke_CI_AS_KS