Oracle's character set (Nls_language) __oracle

The database server character Set select * from Nls_database_parameters, which originates from props$, is the character set representing the database.

The client character set environment select * from Nls_instance_parameters, which originates from V$parameter, represents the setting of the client's character set, possibly a parameter file, an environment variable, or a registry

The session Character set environment select * from Nls_session_parameters, which originates from the V$nls_parameters, represents the session's own settings, either the environment variable of the session or the alter sessions complete. If the session does not have a special setting, it will be consistent with nls_instance_parameters.

The client's character set requires consistency with the server in order to correctly display non-ASCII characters of the database. If multiple settings exist, alter session> environment variables > Registry > Parameter file character sets require consistency, but language settings can be different, and language settings are recommended in English. If the character set is ZHS16GBK, then Nls_lang can be AMERICAN_AMERICA.ZHS16GBK.

Note:

1. Nls_database_parameters and Nls_instance_ can be changed through alter system set nls_language= ' American ' scope=spfile; Parameters's nls_language

2. Through alter session set nls_language= ' Simplified Chinese '; can change nls_session_parameters nls_language