Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!73g2000cwn.googlegroups.com!not-for-mail From: "aman.oracle.dba" Newsgroups: comp.databases.oracle.server Subject: Re: national character set and database set Date: 12 Dec 2006 01:49:35 -0800 Organization: http://groups.google.com Lines: 22 Message-ID: <1165916975.245362.105960@73g2000cwn.googlegroups.com> References: <1165909200.021914.65720@f1g2000cwa.googlegroups.com> <1165913964.79@proxy.dienste.wien.at> NNTP-Posting-Host: 192.127.94.7 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1165916980 5277 127.0.0.1 (12 Dec 2006 09:49:40 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 12 Dec 2006 09:49:40 +0000 (UTC) In-Reply-To: <1165913964.79@proxy.dienste.wien.at> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: 73g2000cwn.googlegroups.com; posting-host=192.127.94.7; posting-account=yp-b7w0AAAAeseIlzSB0lLDs-NuzgUnN Xref: usenetserver.com comp.databases.oracle.server:418970 X-Received-Date: Tue, 12 Dec 2006 04:49:40 EST (text.usenetserver.com) 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 Albe Is it correct that oracle is using only UTF8 for database character set.