Search: For:
Browsing Single Category

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
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
Moderator
 
 
Registered On: Mar 2006
Total Posts: 194
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]