Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: national character set and database set

Re: national character set and database set

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: 12 Dec 2006 01:49:35 -0800
Message-ID: <1165916975.245362.105960@73g2000cwn.googlegroups.com>

Laurenz Albe wrote:
> 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

Is it correct that oracle is using only UTF8 for database character set. Received on Tue Dec 12 2006 - 03:49:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US