Oracle Spin – Flimatech Blog

Sharing Our Database Experience

What is the difference b/w NLS_NCHAR_CHARACTERSET and NLS_NCHAR_CHARACTERSET?

Posted by Amin Jaffer on February 2, 2009

NLS_CHARACTERSET is used for CHAR, VARCHAR2, CLOB columns and NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2, NCLOB columns.

One can find the value of NLS_NCHAR_CHARACTERSET used by the database by running the following SQL:
select value from NLS_DATABASE_PARAMETERS where parameter=’NLS_NCHAR_CHARACTERSET';

VALUE
———————-
AL16UTF16

The possible values for NLS_NCHAR_CHARACTERSET can be UTF8 or AL16UTF16.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 41 other followers

%d bloggers like this: