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 04:11:51 -0800
Message-ID: <1165925511.822205.305400@16g2000cwy.googlegroups.com>

sybrandb wrote:
> On Dec 12, 10:49 am, "aman.oracle.dba" <aman.oracle...._at_gmail.com>
> wrote:
> > Laurenz Albe wrote:
> > > oracle dba <aoracle..._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 AlbeIs it correct that oracle is using only UTF8 for database character set.- Hide quoted text -- Show quoted text -
>
> No. Why don't you read the documentation?
I read them I was surprised that's why I am asking.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Dec 12 2006 - 06:11:51 CST

Original text of this message

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