SQL中文排序

SQL中文排序

sql server：select * from [表名]order by [字段],[字段] collate Chinese_PRC_CS_AS_KS_WS

mysql：select * from [表名] ORDER BY CONVERT([字段] USING gbk);

oracle：

1. 按中文拼音进行排序:SCHINESE_PINYIN_M
   1. SELECT * FROM [表名] ORDER BY NLSSORT(排序字段名,'NLS_SORT = SCHINESE_PINYIN_M');
2. 按中文部首进行排序:SCHINESE_RADICAL_M
   1. SELECT * FROM [表名] ORDER BY NLSSORT(排序字段名,'NLS_SORT = SCHINESE_STROKE_M');
3. 按中文笔画进行排序:SCHINESE_STROKE_M
   1. SELECT * FROM [表名] ORDER BY NLSSORT(排序字段名,'NLS_SORT = SCHINESE_RADICAL_M');