SSH Secure Shell Client Connection Linux command line display Chinese garbled problem and Oracle query data Chinese garbled problem

One, SSH Secure Shell Client Connection Linux command line display Chinese garbled problem

Linux Setup System language

Modify the/etc/sysconfig/i18n file, as

Lang= "en_US. UTF-8 ", Xwindow will display the English interface,

Lang= "ZH_CN. GB18030 ", Xwindow will display the Chinese interface.

There is another way cp/etc/sysconfig/i18n $HOME/.i18n

Modify the $HOME/.i18n file (Vim $HOME/.i18n), as

Lang= "en_US. UTF-8 ", Xwindow will display the English interface,

Lang= "ZH_CN. GB18030 ", Xwindow will display the Chinese interface.

This allows you to change the language of your individual interface without affecting other users. After modification, reconnect the system.

Lang= "en_US. UTF-8 ", the effect is as follows

Lang= "ZH_CN. GB18030 ", the effect is as follows

Second, SSH Secure Shell Client Connection linuxoracle query data Chinese garbled problem

Character set used to query data: SELECT * from Nls_database_parameters;

The rule of Nls_lang is nls_language_nls_territory. Nls_characterset

Sql> select * from Nls_database_parameters; My character set is: Simplified Chinese_china. Zhs16gbk

[Email protected] ~]$ echo $NLS _lang
Simplified Chinese_china. Zhs16gbk

View. bash_profile files under Oracle user,Nls_lang and query are consistent, but without export, modify export nls_lang= "simplified Chinese_china. ZHS16GBK "

[Email protected] ~]$ vim. Bash_profile # Bash_profile

# Get the aliases and functions if [-f ~/.BASHRC]; Then. ~/.BASHRC fi

# User specific environment and startup programs

Oracle_base=/u01/oracle

oracle_home=/u01/oracle/app/12.1.0

Oracle_sid=gfktbb1

nls_lang= "Simplified Chinese_china. ZHS16GBK "

Path= $PATH: $HOME/bin: $ORACLE _home/opatch: $ORACLE _home/bin

Export PATH oracle_base oracle_home oracle_sid

$ source. Bash_profile//Executes the source command to make the modified. bash_profile file Effective
Reconnect Oracle to query Chinese to view.

Chinese garbled

Normal display Chinese

SSH Secure Shell Client Connection Linux command line display Chinese garbled problem and Oracle query data Chinese garbled problem