达梦数据库ORDER BY NLSSORT(name,‘NLS_SORT = SCHINESE_PINYIN_M’)汉字排序

📅 2026/8/26 16:22:50
达梦数据库ORDER BY NLSSORT(name,‘NLS_SORT = SCHINESE_PINYIN_M’)汉字排序
可以使用 NLSSORT 函数实现此功能NLSSORT 支持以拼音、笔画、部首排序示例如下拼音SELECT * FROM PEOPLE ORDER BY NLSSORT(name,‘NLS_SORT SCHINESE_PINYIN_M’);笔划SELECT * FROM PEOPLE ORDER BY NLSSORT(name,‘NLS_SORT SCHINESE_STROKE_M’);部首SELECT * FROM PEOPLE ORDER BY NLSSORT(name,‘NLS_SORT SCHINESE_RADICAL_M’);