OraFAQ Forum: Server Administration » difference between Database character set & National Character Set..?

Home » RDBMS Server » Server Administration » difference between Database character set & National Character Set..?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

difference between Database character set & National Character Set..? [message #265093]

Wed, 05 September 2007 07:17

dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad

Junior Member

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.

Report message to a moderator

Re: difference between Database character set & National Character Set..? [message #265110 is a reply to message #265093]

Wed, 05 September 2007 07:59

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database character set is used in VARCHAR2/CHAR/CLOB datatypes, National Character Set is used in NVARCHAR/NCHAR/NCLOB datatypes.
It is seldomly used now, it is kept for backward compatibility.

Regards
Michel

Report message to a moderator

Re: difference between Database character set & National Character Set..? [message #265129 is a reply to message #265110]

Wed, 05 September 2007 08:37

dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad

Junior Member

Hi.., Mr. Michel,

Thanks for ur reply..

NLS_CHARACTERSET parameter is in NLS_DATABASE_PARAMETERS dictionary table is might be Database character set..,

National Character Set value will be available in which table/view and what is that parameter name..?

Thanks & Regards
Giri K.Y.

Report message to a moderator