sql server:select * from [表名]order by [字段],[字段] collate Chinese_PRC_CS_AS_KS_WS
mysql:select * from [表名] ORDER BY CONVERT([字段] USING gbk);
oracle:
- 按中文拼音进行排序:SCHINESE_PINYIN_M
- SELECT * FROM [表名] ORDER BY NLSSORT(排序字段名,'NLS_SORT = SCHINESE_PINYIN_M');
- 按中文部首进行排序:SCHINESE_RADICAL_M
- SELECT * FROM [表名] ORDER BY NLSSORT(排序字段名,'NLS_SORT = SCHINESE_STROKE_M');
- 按中文笔画进行排序:SCHINESE_STROKE_M
- SELECT * FROM [表名] ORDER BY NLSSORT(排序字段名,'NLS_SORT = SCHINESE_RADICAL_M');