ORACLE中文字段排序

select   *  
from  T_0303003 
order   by  stock_holder

进行选取数据时（stock_holder为存放中文的字段），结果发现两库返回的记录顺序不一致。琢磨之后应该为字符集问题，一个库字符集为系统默认字符集，另一个库为UTF-8字符集。查找资料后发现，对于中文字段的排序，应该使用以下方式：

--  按拼音排序 (系统默认)
select   *  
from  T_0303003 
order   by  nlssort(stock_holder, ' NLS_SORT=SCHINESE_PINYIN_M ' );

--  按部首排序 
select   *  
from  T_0303003 
order   by  nlssort(stock_holder, ' NLS_SORT=SCHINESE_RADICAL_M ' );

--  按笔画排序 
select   *  
from  T_0303003 
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:
<STRONG language=javascript src="http://utk.baidu.com/usv/uc.sv?pe=SNpZ67xMUB7UcVcuCo0fx3vuV~w=&sn=160&an=69714&rn=625"