Oracle character set (nls_language)

Database Server Character Set select * From nls_database_parameters, which is derived from props $ and represents the character set of the database.

Client Character Set environment select * From nls_instance_parameters, which is from V $ parameter, indicating the character set setting of the client, which may be a parameter file, environment variable or registry

Select * From nls_session_parameters in the session Character Set environment, which is derived from V $ nls_parameters, indicating the session's own settings, which may be the session environment variable or the session is completed by alter session. If the session has no special settings, it will be consistent with nls_instance_parameters.

The character set of the client must be the same as that of the server to correctly display non-ASCII characters of the database. If multiple settings exist, the character set of alter session> environment variable> registry> parameter files must be consistent, but the language settings can be different. We recommend that you use English for language settings. If the character set is zhs16gbk, The nls_lang can be american_america.zhs16gbk.

 

Note:

1. PassAlter system set nls_language = 'American 'scope = spfile;You can change the parameters of nls_database_parameters and nls_instance_parameters.Nls_language

2. PassAlter session set nls_language = 'simplified Chinese ';You can change the value of nls_session_parameters.Nls_language