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

Source: Internet
Author: User
Tags i18n ssh secure shell

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.