Wednesday, December 5, 2012

0 Character set and National Character Set

In Oracle Database, it has 2 different character set, character set and National character set. The character set is used for all normal data types such as VARCHAR2. National character set is used for NVARCHAR2.

How to check the character set and national character set for the database.

  • PROPS$
  • V$NLS_PARAMETERS
  • NLS_DATABASE_PARAMETERS
select * from PROPS$;

image

col parameter format a30
col value format a32
select * from V$NLS_PARAMETERS;

image

col parameter format a30
col value format a32
select * from NLS_DATABASE_PARAMETERS;

image

Reference

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates