I located a better article on the above subject and thought of sharing it with you:
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