Oracle 9i CHARACTERSET
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;
and much more lines.
Now, what should I do in order to set the database to UNI-CODE?
WE8MSWIN1252 is not UNICODE characterset.
You may need to choose from the following if you want unicode cs.
I dont think there is any dict. view available to check if unicode is supported. You should derive it by charactersets.