OraFAQ Forum: Server Administration » Change to UTF8 character set

Home » RDBMS Server » Server Administration » Change to UTF8 character set

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

Change to UTF8 character set [message #171574]

Wed, 10 May 2006 07:55

rafi_aamiri
Messages: 34
Registered: September 2005

Member

Hi,

Currently the character set available is WE8MSWIN1252 and I need it to change to UTF8.

When I tried to change then it throws an error saying that it should be superset of the current character set.

Please let me know how to resolve this issue ?

Thanks and Regards,

A.Mohammed Rafi.

Report message to a moderator

Re: Change to UTF8 character set [message #171575 is a reply to message #171574]

Wed, 10 May 2006 07:57

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

How did you try to change??

Report message to a moderator

Re: Change to UTF8 character set [message #171579 is a reply to message #171575]

Wed, 10 May 2006 08:07

rafi_aamiri
Messages: 34
Registered: September 2005

Member

first shutdown database

then mount the datbase

the open the database

then alter database set character set UTF8

Report message to a moderator

Re: Change to UTF8 character set [message #171595 is a reply to message #171574]

Wed, 10 May 2006 08:57

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

The error is coming because utf8 is not a superset of your previous character set. By superset it means it should contain all the characters defined in the subset which is not the case here.

Report message to a moderator