Re: Oracle 9i NLS_CHARACTERSET
From: Laurenz Albe <invite_at_spam.to.invalid>
Date: Fri, 20 Nov 2009 08:38:49 +0100
Message-ID: <1258702750.381122_at_proxy.dienste.wien.at>
Barney wrote:
> In the table NLS_DATABASE_PARAMETERS, if I see that the value of
> NLS_CHARACTERSET has been set to a particular value (let's say to
> « WE8ISO8859P1 »), is it possible to change or to override it in some
> way ?
Date: Fri, 20 Nov 2009 08:38:49 +0100
Message-ID: <1258702750.381122_at_proxy.dienste.wien.at>
Barney wrote:
> In the table NLS_DATABASE_PARAMETERS, if I see that the value of
> NLS_CHARACTERSET has been set to a particular value (let's say to
> « WE8ISO8859P1 »), is it possible to change or to override it in some
> way ?
Not easily, no.
There is a lengthy Metalink note (260192.1) that shows all the steps and pitfalls involved in changing from WE8ISO8859P1 to AL32UTF8. Depending on what your original problem is, NVARCHAR2 and friends might be helpful.
Yours,
Laurenz Albe
Received on Fri Nov 20 2009 - 01:38:49 CST