character set conversion: AL24UTFFSS to UTF8

From: <k_a_h_l_i_l_at_yahoo.com>
Date: Tue, 02 Jan 2001 05:12:23 GMT
Message-ID: <92rnvk$64h$1@nnrp1.deja.com>

Hello,

I have a db in AL24UTFFSS for both database charset and national charset data in NVARCHAR fields. I would like to convert these all to UTF8. When I try using "alter database character set UTF8" I get this error:

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

Can anyone tell me how to do this conversion? All user data is currently in plain English, so there shouldn't be any problem with data corruption.

Thanks
-Matt

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 01 2001 - 23:12:23 CST