Oracle Database Discussions

Hi,

I need to sort the Chinese characters in my database, without changing the NLS_LANG paramater.
Initially, I just changed the NLS_SORT setting for my session by -

SQL> alter session set NLS_SORT=SCHINESE_STROKE_M;

After I queried the table and did an order by, I got a particular order of the words, which was different from the order I got when NLS_SORT=BINARY.
I have no way to know if the order is correct or not, as I do not understand Chinese, but I assumed it to be correct.

Next, I changed the NLS_SORT for the system by -

SQL> alter system set NLS_SORT='SCHINESE_STROKE_M' scope=spfile;
SQL> SHUTDOWN IMMEDIATE;
sql> STARTUP;

When I do a -
SQL> Show parameter NLS_SORT; I get the following output -
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string SCHINESE_STROKE_M

But when I query the database, with an order by clause, the data does not happen to be in the order that I received when I had changed the setting for session. In fact, the order is the same when the NLS_SORT=BINARY.

Am I doing anything wrong?
Please help.