Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oracle 9i NLS_CHARACTERSET

12 views
Skip to first unread message

Barney

unread,
Nov 19, 2009, 3:57:21 PM11/19/09
to
Hi,

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 ?

Thank you.

Message has been deleted

joel garry

unread,
Nov 19, 2009, 5:46:47 PM11/19/09
to

What exactly do you want to accomplish? This defines what characters
are allowed to go into the database. It is possible to use normal
tools to get around this, although when you subsequently move the data
it can be altered, and if you read the data with another characterset
that is not a sub or superset you can get strangeness. There are
several documents on MOS that explain some things in detail, and a
couple of globalization manuals at tahiti.oracle.com (and elsewhere).

jg
--
@home.com is bogus.
http://oss.oracle.com/~wcoekaer/lego5.jpg Don't you want to just
photoshop in a "Defect Inside" sash?

Laurenz Albe

unread,
Nov 20, 2009, 2:38:49 AM11/20/09
to

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


0 new messages