RedHat5.4Oracle11gSqlplus Chinese garbled Solution

[Problem description] 1. the file names containing Chinese Characters in Linux are garbled; 2. use the vi editor to view Chinese characters with garbled characters. 3. sqlplus enters the database to view the Chinese content as garbled; 4. the Chinese content in putty is garbled. [Cause] 1. no packages supported by Chinese characters are installed; 2. corresponding environment variables need to be adjusted [problem handling] 1. confirm the system version # cat/etc/RedHat-releaseRedHatEnterpriseLinuxS

[Problem description]
1. garbled characters are displayed for file names containing Chinese Characters in Linux;
2. Use the vi editor to view Chinese characters with garbled characters;
3. sqlplus enters the database to view Chinese characters with garbled characters;
4. The Chinese content in putty is garbled.

[Cause]
1. No packages supported by Chinese characters are installed;
2. The corresponding environment variables need to be adjusted accordingly.

[Troubleshooting]
1. Confirm the system version
# Cat/etc/RedHat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)

2. Check whether the fonts-chinese language support package has been installed in linux. If not, download the rpm package of the corresponding version for installation.
# Rpm-aq | grep fonts-chinese
Fonts-chinese-3.02-12.el5

3. Modify the/etc/sysconfig/i18n file as follows:
LANG = "zh_CN.GB18030"
LANGUAGE = "zh_CN.GB18030: zh_CN.GB2312: zh_CN"
SUPPORTED = "zh_CN.GB18030: zh_CN: zh: en_US.UTF-8: en_US: en"
SYSFONT = "lata0-sun16"
SYSFONTACM = "8859-15"
# Export LC_ALL = "zh_CN.GB18030"

Export can be added or not

4. Add the following content at the end of/etc/profile:
# Export LC_ALL = "zh_CN.GB18030"

5. log out or reboot. The problem of garbled characters in the file names containing Chinese characters in the Linux System and the problem of using the vi editor to view Chinese characters as garbled characters is solved.

6. Add the following content to the. bash_profile of the Oracle user to solve the problem of SQL plus entering the database and Viewing Chinese content as garbled characters.
Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

Check that the character set of the database is ZBS16GBK.

Select * from nls_database_parameters;

Field NLS_Charset .. display

7. set the plain Ed data assumed to be in which character set in the Window-Translation in putty to ISO-8859-1: 1998 (Latin-1, West Europe) to solve the problem of garbled Chinese content in putty.

So far, Chinese garbled characters have been solved.