Issue to store Chinese character to Oracle9i
Posted on 2006-07-23
I have a question regarding to storing chinese characters in oracle 9i (rel 2) db, I use unicode data type to implement it instead of a unicode database.
My current db settings for NLS are:
1 NLS_CHARACTERSET WE8MSWIN1252
2 NLS_NCHAR_CHARACTERSET AL16UTF16
My Client setting for NLS_LANG (system environment variables)
My operating system is Win2000 and its default locale is Chinese.
I can see chinese characters in SQLPLUS:
In SQLPLUS, I create a table
create table test (mynvarchar2 nvarchar2(10));
insert into test values ('[some chinese chars]');
select * from test;
It shows ???...
Any advice on the above ?