Query to check nls_characterset parameter of database


sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 4 00:39:24 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’;

VALUE$
——————————————————————————–
WE8ISO8859P1

SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_NCHAR_CHARACTERSET’;

VALUE$
——————————————————————————–
AL16UTF16

Advertisements

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