How to make Oracle client display Chinese

This article mainly introduces how to make the Oracle client display Chinese, the article is very detailed, has a certain reference value, interested friends must read it!

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

The NLS_LANG parameter consists of the following parts:

NLS_LANG=_.

The meanings of each part of NLS_LANG are as follows:

LANGUAGE specifies the language, date, mid-month, and day display format used by Oracle messages

TERRITORY specifies currency and number formats, regions, and habits for calculating days of the week and date

CHARACTERSET controls the character set used by client applications

So how to make the client of Oracle display Chinese? The premise is that the character set of Oracle is super that supports Chinese character set. Our commonly used character sets are gbk and utf8.

After that, we define the NLS_LANG variable at the operating system level to support Chinese, which is not enough. We need to keep the character sets of the server, the client, the system and the terminals we use consistent.

Generally speaking, we have the following two choices for NLS_LANG, and the terminal fonts corresponding to these two choices need to be adjusted accordingly:

The terminal font corresponding to export NLS_LANG='simplified chinese_china.al32utf8' is adjusted to utf8.

The terminal font corresponding to export NLS_LANG='simplified chinese_china.zhs16gbk' is adjusted to gbk.

The above is all the contents of the article "how to make the Oracle client display Chinese". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!