www.dbatoolz.com › ORACLE DBA Forums › Forum › Topic Id: 2588 | Permalink

Database character set & National Character Set..?

Topic ID: 2588
Created By:	2007-SEP-05 04:35:01 [Dba_Giri]
Updated By:	2007-SEP-05 14:47:38 [Vitaliy]
Status:	Open
Severity:	Normal
Read Only:	No

8182

2007-SEP-05 04:35:01

Dba_Giri

User

Registered On: Jul 2007

Total Posts: 7

Hi..,
What is the difference between Database character set & National Character 
Set..?
I think if I use the Database character set as Unicode (AL32UTF8) it accepts 
the data in any language..
but what is National Character Set ?

Thanks in Advance
Giri K.Y.

8187

2007-SEP-05 14:46:44

Vitaliy

Moderator

Registered On: Mar 2006

Total Posts: 233

Here's a quote from Oracle's metalink Note:276914.1 The National Character Set 
in Oracle 9i and 10g:

  "1) What is the National Character Set?
   
      The NLS_CHARACTERSET is used for CHAR, VARCHAR2, CLOB columns;
      The NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2, NCLOB columns.
   
      NLS_NCHAR_CHARACTERSET is defined when the database is created 
      and specified with the CREATE DATABASE command.
      The NLS_NCHAR_CHARACTERSET defaults to AL16UTF16 if nothing is 
      specified."

HTH,
- Vitaliy

[edited by: Vitaliy at 14:47 (CST) on Sep. 05, 2007]

Permalink