Oracle Character Set Summary

(1). Oracle Database Server Character Set select * fromnls_database_parameters comes from props $, which indicates the character set of the database. (2). Client Character Set

(1). Oracle Database Server Character Set select * from nls_database_parameters comes from props $, which indicates the character set of the database. (2). Client Character Set

(1). Oracle Database Server Character Set

Select * from nls_database_parameters

The source is props $, which indicates the character set of the database.

(2). Client Character Set Environment

Select * from nls_instance_parameters

It is derived from v $ parameter, which indicates the character set setting of the client, which may be a parameter file, environment variable, or registry.

(3). Session Character Set Environment

Select * from nls_session_parameters

The source is v $ nls_parameters, which indicates the session's own settings. It may be the session's environment variable or the alter session is completed. If the session has no special settings, it will be consistent with nls_instance_parameters.

(4). Only when the character set of the client must be the same as that of the server can the non-Ascii characters of the database be correctly displayed.

If multiple settings exist, NLS takes precedence over SQL function> alter session> environment variables or registry> parameter files> default database Parameters

Expdp Character Set settings

SQL> select userenv ('language') from dual;

USERENV ('language ')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

Set NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8

This article permanently updates the link address: