达梦数据库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(…
2026/8/26 16:22:50