Oracle database and client character sets

1. View database Character Set information

Sql> select * from Nls_database_parameters;

Where Nls_characterset is the character set of the current database.

2. Client Character Set

The parameters for the client character set are Nls_lang.

In Windows, query and modify Nls_lang can be set in the registry key hkey_local_machine\software\oracle\homexx\, XX refers to the system number when there are multiple oracle_home.

In Unix, you set the client character set by setting the Nls_lang environment variable.
View Nls_lang environment variable values
$ env|grep Nls_lang
Nls_lang=simplified Chinese_china. Zhs16gbk
Modifying the Nls_lang environment variable value
$ export Nls_lang=american_america. UTF8

Oracle database and client character sets