what's chinese sorting ?

 I located a better article on the above subject and thought of sharing it with you:  

http://www.oracle.com/technology/obe/obe9ir2/obe-nls/sort/sort.htm?_template=/ocom/technology/content/print

This article contains a very clear demo showing us how we could alter the default sorting order by adjusting the NLS_SORT parameter:

 

alter session set nls_sort=schinese_pinyin_m;

alter session set nls_sort=schinese_stroke_m;
   

 

 

Attached hereby is the script files used in this demo. These script files would create the test table and populate chinese character data into it for running the following query:

 

select translated_name, language_id

  from product_descriptions_sort

  where language_id='ZHS'

  order by translated_name;

 

 

The article also touches on building of dedicate FBI to support this searching.

 

Please share this article with all the colleagues who are interested in this subject.

 

Thanks.

 

Rgds, daniel