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

📅 发布时间:2026/8/26 16:23:09
达梦数据库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’);