Oracle Database Character Set query

1> Database Server Character Set

SELECT * from Nls_database_parameters, which is derived from props$, is the character set representing the database.

The query results are as follows

Nls_language AMERICAN
Nls_territoryamerica
nls_currency$
Nls_iso_currencyamerica
Nls_numeric_characters.,
Nls_characterset Al32utf8
Nls_calendargregorian
Nls_date_formatdd-mon-rr
Nls_date_languageamerican
Nls_sortbinary
Nls_time_formathh.mi. Ssxff AM
NLS_TIMESTAMP_FORMATDD-MON-RR HH.MI. Ssxff AM
Nls_time_tz_formathh.mi. Ssxff AM TZR
NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI. Ssxff AM TZR
nls_dual_currency$
Nls_compbinary
Nls_length_semanticsbyte
Nls_nchar_conv_excpfalse
Nls_nchar_characterset Al16utf16
nls_rdbms_version11.2.0.2.0

The difference between 1.1>nls_characterset and Nls_nchar_characterset

Nls_characterset: is the database character set;

Nls_nchar_characterset: is the national character set;

There are two major types of character data in Oracle:

VARCHAR2: data is stored according to the database character set.

NVARCHAR2: data is stored according to the national character set.

CHAR: data is stored according to the database character set.

NCHAR: data is stored according to the national character set.

　　

2> Client Character Set environment

SELECT * from Nls_instance_parameters, which originates from V$parameter,

Oracle Database Character Set query