Re: national character set and database set

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 12 Dec 2006 08:59:24 GMT
Message-ID: <1165913964.79@proxy.dienste.wien.at>

oracle dba <aoracledba_at_gmail.com> wrote:
> what is the difference in national character set and database set of a
> database.
> how is it effect the data of database.

Please read the documentation!

The national character set is the character set used in NCHAR, NVARCHAR2 and NCLOB columns. For all other text columns, the database character set is used.

The national character set basically is a wart, probably originating in the times when it was not possible or safe to have a UNICODE database character set. I cannot think of any good use case in a 10g database.

Yours,
Laurenz Albe Received on Tue Dec 12 2006 - 02:59:24 CST