-
Oracle 9i CHARACTERSET
Hello,
We have installed the Oracle 9i database (fresh installation) using the CHARACTERSET WE8ISO8859P1.
Later on we figured it out that we need the CHARACTERSET WE8MSWIN1252 and with UNI-CODE enabled.
What I have done is:
I have started the database in a restricted mode.
then I issued the following command:
alter database character set WE8MSWIN1252;
select * from NLS_DATABASE_PARAMETERS;
NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16
and much more lines.
Now, what should I do in order to set the database to UNI-CODE?
Thank you,
Nikee
-
Hi Nikee,
WE8MSWIN1252 is not UNICODE characterset.
You may need to choose from the following if you want unicode cs.
UTF8,UTFE,AL32UTF8,AL16UTF16.
I dont think there is any dict. view available to check if unicode is supported. You should derive it by charactersets.
Thks,
Sunil