OraFAQ Forum: Server Administration » Changing Character set

Home » RDBMS Server » Server Administration » Changing Character set

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

Changing Character set [message #321580]

Tue, 20 May 2008 14:48

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi Friends,
i am new to this forum. and i have a doubt that i like to change the character set in oracle 10g from AL32UTF8 to WE8MSWIN1252.

When i used the following command, i received a error,

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

Please give me a solution for this.

Thanks in Advance,

Seenu

Report message to a moderator

Re: Changing Character set [message #321587 is a reply to message #321580]

Tue, 20 May 2008 15:21

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

Senior Member
Account Moderator

Quote:

When i used the following command

Which one?

Quote:

ORA-12712: new character set must be a superset of old character set
Cause: When you ALTER DATABASE ... CHARACTER SET, the new character set must be a superset of the old character set. For example, WE8ISO8859P1 is not a superset of the WE8DEC.
Action: Specify a superset character set.

WE8MSWIN1252 is NOT a superset of AL32UTF8, you can't do that, you have to recreate the database.

Regards
Michel

Report message to a moderator

Re: Changing Character set [message #321605 is a reply to message #321587]

Tue, 20 May 2008 19:35

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Thanks a lot michel.

Is there any other way to change the character set than recreate the database because its production database.

Thanks and Regards,

Seenu

Report message to a moderator