Hi,

I'm wading my way through all the NLS doumentation for 9i, and although it
has improved vastly, it has also become quite huge!

I'm trying to see if our application will store double-byte characters. I'm
having trouble getting this to work with an English version of Windows. Do
I need a Chinese version of Windows? (the language I'm trying to test?)

I've tried changing the locale in regional settings, but I still get English
input using SQL*Plus Worksheet. I tried setting the ACP to 952 in the
registry, but then Windows wouldn't boot! My understanding is that the NLS
setting on the client MUST match the code page the o/s is actually using.

I'm using 9i, UTF16 characterset for the database.

Thanks in advance,
db

Set the clients' NLS_LANG env variable to Chinese
Change the keyboard type to Chinese
Change the locate to Chinese, then try it.

Good luck.


"dsb" <dana (AT) iqms (DOT) com> wrote

ad so...)

If you want to see chinese characters in your sqlplus you must set the
sqlfont properly (old 'courier new' won't help you here)

Also, you can use sql scratchpad or isql to see the chinese data.

No you don't. If you are storing chinese in UTF16 (as NVARCHARS) you
can use DUMP() function in sqlplus to see how your DB is actually
storing your data. (Maybe you will not see the chinese characters, but
you will be able to know if they are stored in the DB OK).

Nope. NLS settings only concern the client connection with the DB.
Nothing to do with the client 'national' OS.

In all above situations you must have a font installed which is
capable to represent the chinese characters.

Regards.

Carlos.

"dsb" <dana (AT) iqms (DOT) com> wrote