Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Tue, 12 Dec 2006 09:21:51 -0800 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: national character set and database set References: <1165909200.021914.65720@f1g2000cwa.googlegroups.com> <1165913964.79@proxy.dienste.wien.at> <1165916975.245362.105960@73g2000cwn.googlegroups.com> <1165920533.412684.174610@80g2000cwy.googlegroups.com> <1165925511.822205.305400@16g2000cwy.googlegroups.com> In-Reply-To: <1165925511.822205.305400@16g2000cwy.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1165944110.995009@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 32 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.server:419028 X-Received-Date: Tue, 12 Dec 2006 12:21:51 EST (text.usenetserver.com) aman.oracle.dba wrote: > sybrandb wrote: >> On Dec 12, 10:49 am, "aman.oracle.dba" >> wrote: >>> Laurenz Albe wrote: >>>> oracle dba 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@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org