Home » RDBMS Server » Server Administration » difference between Database character set & National Character Set..?
difference between Database character set & National Character Set..? [message #265093] Wed, 05 September 2007 07:17 Go to next message
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.
Re: difference between Database character set & National Character Set..? [message #265110 is a reply to message #265093] Wed, 05 September 2007 07:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: difference between Database character set & National Character Set..? [message #265129 is a reply to message #265110] Wed, 05 September 2007 08:37 Go to previous messageGo to next message
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.

Re: difference between Database character set & National Character Set..? [message #265132 is a reply to message #265129] Wed, 05 September 2007 08:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same view, parameter NLS_NCHAR_CHARACTERSET

Regards
Michel
Re: difference between Database character set & National Character Set..? [message #265197 is a reply to message #265132] Wed, 05 September 2007 13:41 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.oracle-base.com/forums/viewtopic.php?f=1&t=8724 Thumbs Up
Previous Topic: partitioned table
Next Topic: Recovering a lost schema password
Goto Forum:
  


Current Time: Tue Dec 06 02:56:15 CST 2016

Total time taken to generate the page: 0.05347 seconds