Home » RDBMS Server » Server Administration » how to convert a latin-1 db to utf-8 database. (Oracle 10g, Linux Redhat.)
how to convert a latin-1 db to utf-8 database. [message #324741] Tue, 03 June 2008 19:20 Go to next message
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
Re: how to convert a latin-1 db to utf-8 database. [message #324743 is a reply to message #324741] Tue, 03 June 2008 20:02 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>what is a good way of converting the database character set and national character set ?
In your case the ONLY way is to do exp/imp.
Previous Topic: Database or data Move
Next Topic: TEMPFILE cannot be dropped at this time
Goto Forum:
  


Current Time: Thu Dec 08 22:15:19 CST 2016

Total time taken to generate the page: 0.08733 seconds