Oracle Database Chinese Character sorting

Oracle Database Chinese Character sorting needs to be sorted by a certain Chinese field of a table in oracle Database today. It seems quite simple, not just order, however, it was not right after writing the findings, and it was incredible for a while. I found this problem. After checking the information, I found that, oracle sorts Chinese by the value of the ASC code. Later, after reading the documents, it found a function.

1. sort by pinyin: select * from your_table_name t order by nlssort (t. ordered_column_name, 'nls _ SORT = SCHINESE_PINYIN_M ') 2. SORT by number of strokes: select * from your_table_name t order by nlssort (t. ordered_column_name, 'nls _ SORT = SCHINESE_STROKE_M ') 3. SORT by radicals: select * from your_table_name t order by nlssort (t. ordered_column_name, 'nls _ SORT = SCHINESE_RADICAL_M ') Explanation: SCHINESE_PINYIN_M ===& gt; Simplified Chinese Pinyin Mode