java - oracle对汉字字段按照拼音排序的函数和sql语句是什么？

Question

除了order By nlssort(colname,'NLS_SORT=SCHINESE_PINYIN_M')外，还有其他的方法或函数吗？

Answer 1

If you don’t use Oracle’s own NLS sorting function, you can add a Pinyin field to the table, assign the value yourself when inserting the record, and then sort according to the Pinyin field.

This method is less flexible and requires the sorting field to be relatively fixed.

Answer 2

Link description
please refer to it