Change Chracter Set - UTF8 to US7ASCII 
Author Message
 Change Chracter Set - UTF8 to US7ASCII
Hi,

Is it possible to change the character set of a database from UTF8 back to
US7ASCII. We have no data in the database that should use UTF8 - we imported
data from a database with US7ASCII character set.

When I try the alter database command I get an error 12712 saying it must be
a superset.

I am trying to avoid a restore (large database).

thanks in advance,

JP



Wed, 14 Jan 2004 00:06:56 GMT
 Change Chracter Set - UTF8 to US7ASCII

You cannot go back once you commit to UTF8.  If you want US7ASCII you will
have to export all of your data, burn the database to the ground, rebuild,
and import your data.

When you export you can specify the character set to use.

Good Luck,
Chris Weiss


Quote:
> Hi,

> Is it possible to change the character set of a database from UTF8 back to
> US7ASCII. We have no data in the database that should use UTF8 - we
imported
> data from a database with US7ASCII character set.

> When I try the alter database command I get an error 12712 saying it must
be
> a superset.

> I am trying to avoid a restore (large database).

> thanks in advance,

> JP



Wed, 14 Jan 2004 03:51:05 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Characters beyond ASCII in database ( US7ASCII and UTF8 character set )

2. US7ASCII vs UTF8 performance

3. How do I migrate from US7ASCII on 8.0.5 to UTF8 on 8i

4. Database conversion from US7ASCII to UTF8

5. changing nls_characters set from US7ASCII to WE8ISO8859P1 in Oracle 8.0.5

6. Character set conversion to UTF8 from WE8ISO8859P1 to UTF8

7. Solution: UCS2 / UTF8 / Oracle / Fail to convert between UTF8 and UCS2

8. setting NLS client property to utf8 charset

9. database character sets utf8

10. character set conversion: AL24UTFFSS to UTF8

11. Export & Import with UTF8 Character Set

12. Empty String seen as NULL field by ASE 11.9.2 with utf8 code set


 
Powered by phpBB® Forum Software