Re: CHANGE CHARACTER SET US7ACII --> WE8ISO8859P1 - Error?

"Jeremy Ovenden" <jovenden_at_hazelweb.co.uk> wrote in message news:<tj6kb715fnsbf_at_xo.supernews.co.uk>...
> I have researched how to change the character set on an Oracle8 database.
> This involves several steps in svrmgr (omitted here) but this one errors:
>
> SVRMGR> ALTER DATABASE CHARACTER SET WE8ISO8859P1;
>
> When I issue this, I get the error
> ORA-12710: new character set must be a superset of old character set
>
> The documentation says you can do this e.g. from US7ASCII to the specified
> character set...but why won't it work for me? Have Oracle 8.0.6 on Solaris
> 2.7
>
> Thanks for any advice!
> --

It's possible that WE8ISO8859P1 may not support all the languages/charsets that US7ASCII supports. I have no problem in changing my db charset to WE8ISO8859P15 from US7ASCII. You may want to verify Oracle docs to get the supported charsets/languages. Received on Fri Jun 22 2001 - 14:18:58 CDT