ORACLE中文字段排序

做一個2個資料庫間資料比較工具時遇到ORACLE中漢字排序的問題。

使用一下SQL

select * 

from T_0303003 

order by stock_holder

進行選取資料時（stock_holder為存放中文的字段），結果發現兩庫傳回的記錄順序不一緻。琢磨之後應該為字元集問題，一個庫字元集為系統預設字元集，另一個庫為UTF-8字元集。查找資料後發現，對于中文字段的排序，應該使用以下方式：

-- 按拼音排序 (系統預設)

order by nlssort(stock_holder,'NLS_SORT=SCHINESE_PINYIN_M');

-- 按部首排序 

order by nlssort(stock_holder,'NLS_SORT=SCHINESE_RADICAL_M');

-- 按筆畫排序 

order by nlssort(stock_holder,'NLS_SORT=SCHINESE_STROKE_M');

ORACL官方論壇讨論：

http://www.oracle-database.cn/oracle_database_It-english-database-0-251288.html

Have found a strange question recently, arrange in an order Chinese character order by in oracle, " crocodile's word has been ranked at the end to appear! Whether there is such a situation to know the greater part. Whether it is bug i

-----------------------------------------------------------

NLS _ SORT? ??

answer2:

1 perhaps this word is many sound words. 2 says and says according to what way you want to arrange in an order.

ans wer3:

arranges in an order according to the spelling, should need to set up NLS _ SORT. Have Still in test test finish tell and then you body.

answer4:

O In RACLE, arrange in an order question 1. //Arrange in an order 2 according to the stroke. select * from dept order by nlssort(name,NLS _ SORT =SCHINESE _ STROKE _ M); 3.//Press Take the radical and arrange in an order 4. select * from dept order by nlssort(name,NLS _ SORT =SCHINESE _ RADICAL _ M); 5.//Arrange in an order according to the spelling, this arranges in an order the side for systematic acquiescenc Formula 6. select * from dept order by nlssort(name,NLS _ SORT =SCHINESE _ PINYIN _ M); Can revise NLS _ SORT parameter