From: k_a_h_l_i_l@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: character set conversion: AL24UTFFSS to UTF8
Date: Tue, 02 Jan 2001 05:12:23 GMT
Organization: Deja.com
Lines: 19
Message-ID: <92rnvk$64h$1@nnrp1.deja.com>
NNTP-Posting-Host: 208.246.78.94
X-Article-Creation-Date: Tue Jan 02 05:12:23 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98)
X-Http-Proxy: 1.1 x59.deja.com:80 (Squid/1.1.22) for client 208.246.78.94
X-MyDeja-Info: XMYDJUIDmattwong


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/