Hi All

What is way to change CHARACTER SET for the database ?
I have created Database in Oracle 8.1.6 with CHARACTER SET WE8ISO8859P1. Since this is 8-bit character set it will not support unicode charachetrs. I need the columns to accept NVACHAR / NCHAR values.

So as to change CHARACTER SET, i already workout following process.

1. SHUTDOWN IMMEDIATE; " BACKED UP DATABASE "
2. STARTUP MOUNT;
3. ALTER SYSTEM ENABLE RESTRICTED SESSION;
4. ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0;
5. ALTER DATABASE OPEN;
6. ALTER DATABASE CHARACTER SET AL16UTF16;

SETP 6 HAS GIVEN FOLLOWING ERROR

ALTER DATABASE CHARACTER SET AL16UTF16
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set

Can any one help me out ? Do i need to recreate database again? what should be ideal character set for my scenario ?