how to convert a latin-1 db to utf-8 database. [message #324741] |
Tue, 03 June 2008 19:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
geeklol
Messages: 59 Registered: March 2005
|
Member |
|
|
I have a latin-1 database and i am trying to convert the characterset from latin-1 to UTF-8.
So i shutdown the db and then restarted it in a restricted mode. but i am getting the following error: what is a good way of converting the database character set and national character set ?
SQL> alter database character set AL32UTF8;
alter database character set AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
SQL> ALTER DATABASE NATIONAL CHARACTER SET UTF8;
ALTER DATABASE NATIONAL CHARACTER SET UTF8
*
ERROR at line 1:
ORA-12717: Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR
or NVARCHAR2 data exists
Thank you,
Kalpa
|
|
|
|