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: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Dec 2006 09:21:51 -0800
Message-ID: <1165944110.995009@bubbleator.drizzle.com>


aman.oracle.dba wrote:

> 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.

Which Oracle doc states that UTF8 is the only character set? Please provide a link.
Thank you.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Dec 12 2006 - 11:21:51 CST

Original text of this message

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