OraFAQ Forum: Server Utilities » Changing Characterset from AL16UTF16 to AL32UTF8

Home » RDBMS Server » Server Utilities » Changing Characterset from AL16UTF16 to AL32UTF8

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing Characterset from AL16UTF16 to AL32UTF8 [message #240494]

Fri, 25 May 2007 01:14

newtooracle123
Messages: 24
Registered: May 2007

Junior Member

Hi,

I am using oracle 10g database.
I want to change the characterset from AL16UTF16 to AL32UTF8.
How can I do it?
How can I test the same after changing it?

Thank you

[Updated on: Fri, 25 May 2007 08:11] by Moderator

Report message to a moderator

Re: [URGENT] Changing Characterset from AL16UTF16 to AL32UTF8 [message #240510 is a reply to message #240494]

Fri, 25 May 2007 02:02

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

export full
recreate the database with new character set
import full

Regards
Michem

Report message to a moderator

Re: [URGENT] Changing Characterset from AL16UTF16 to AL32UTF8 [message #240513 is a reply to message #240510]

Fri, 25 May 2007 02:12

newtooracle123
Messages: 24
Registered: May 2007

Junior Member

ok..

But cant I change the characterset after creation of database using the below alter statement:

ALTER DATABASE CHARACTER SET al32utf8

when I tried it I got an error saying:

ORA-12712: new character set must be a superset of old character set

can you suggest something

Report message to a moderator