Hi All,
Oracle 11G on Windows 2008 R2.
I am trying to figure out how (if possible) I can store Chinese characters into my existing database, particularly into an existing table. My language settings are as follows on the database:
[code]
SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER LIKE '%CHARACTERSET';
PARAMETER VALUE
NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET UTF8
[/code]
My existing table has 2 columns (DESC varchar(20), SHORT_DESC varchar(20)) and when I try to do an import of Chinese characters into them, they display as ?' (upside down).
I have read that since my NLS_NCHAR_CHARACTERSET is set to UTF8, I can change the columns to NVARCHAR and it should accept the Chinese characters. Though when I did change the columns to NVARCHAR, they still display as an upside down question mark, so I assume it is not storing them properly.
Is it possible for me to store the Chinese characters into my existing table?
Thanks in advance.