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