How to enable Oracle clients to display Chinese

The character set of Oracle is determined by the parameter Nls_lang:

The Nls_lang parameter consists of the following parts:

Nls_lang=<language>_<territory>.<clients characterset>

Nls_lang the meanings of each part are as follows:

language specifies the language to use for Oracle messages, the month and day display formats for dates

Territory specify currency and number formats, regions, and the habit of calculating week and date

CharacterSet controlling the character set used by client applications

So how do you get Oracle's client to display Chinese? The premise is that Oracle's character set is super-supported in Chinese character sets, and our common character sets are GBK and UTF8

Then we define the Nls_lang variable at the OS level to support Chinese, which is not enough, we have to keep the character set of the server, client, system, and terminal we use consistent.

Nls_lang we generally have the following two choices, these 2 options corresponding to the terminal font also need to make corresponding adjustments:

Export nls_lang= ' simplified Chinese_china.al32utf8 ' corresponding terminal font to UTF8

Export nls_lang= ' simplified CHINESE_CHINA.ZHS16GBK ' corresponding terminal font to GBK

How to enable Oracle clients to display Chinese