Re: alter database national character set utf8; ---> ora-12712

In article <90ndjs$puu$1_at_nnrp1.deja.com>,   Rene Nyffenegger <renenyffenegger_at_my-deja.com> wrote:
> Hi
>
> I tried to alter the national character set of an oracle instance by
> issuing
>
> alter database national character set utf8;
>
> but failed. Oracle says: ORA-12712 Der Zeichensatz muss eine Obermenge
> des alten Zeichensatzes sein. (which translates to something like
> the new characterset must be a superset of the old one)
>
> Inteterstingly enough, I get the very same error message if I try
> to use a totally ridicolous character set as in
>
> alter database national character set blablabla;
>
> Who can help me?
>
> TIA
>
> Rene
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

IIRC you can't change a single-byte characterset to a multi-byte characterset, like UTF-8. This is not surprising, IMO. The NLS appendix in the server administrators guide has a list of compatible charactersets.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.