Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: national character set and database set
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?
-- Sybrand Bakker Senior Oracle DBAReceived on Tue Dec 12 2006 - 04:48:53 CST