migration of default character set to UNICODE CAHRACTERE SET

[rahul.wankhede]

Dear all
I want to migrate my default character set database WE8..... TO UNICODE CHARACTER SET.
hOW CAN I PROCCED WITH THAT.

i HAVE TAKEN THE SCHEMA AS WELL AS FULL EXP BACKUP.

LATER AI HAVE CREATED THE NEW DATABASE WITH AL32UTF8 CHARACTER SET. AND IMPORT BUT GIVING ME ????? IN PLACE OF DATA IS USER TABLE.

aLSO I HAVE CHANGE THE DATATYPE WITH THE HELP OF
ALTER TABLE MODIFY (COL NVARCHAR2(50); FROM VARCHAR2(50))
STILL ITS GIVING ME ????? ON
SELECT * FROM ;

pLZ HELP ME OUT HOW CAN I PROCCED WITH DATABASE MIGRATION.
mY DEVELOPER HAD ALREADY IMPORTED THE DATABASE WITH ASIAN LANGAUAGE.

THANKS

[monto1]

if migrating characterset is strict superset of the database you are migrating from then you could use 'alter database character set '.

[rahul.wankhede]

Hi monto1,
But what does it mean and where cud i found that my existing database is an superset of target database.
Also with 'alter database character set' will not change the data.

Thanks

[monto1]

Create new database with unicode characterset(AL32UTF8) ,pre-create your tablespaces and import data into it,thats it. Unicode characterset supports
all languages.