The problem of Sqlplus Chinese characters

Today in the Sqlplus test encountered the problem of Chinese garbled, when it comes to garbled problem is the first thought is the character set inconsistency.

1. Problem Description: Error caused by password input error when logging in, but display result is garbled.

   
   

   650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/7C/74/wKioL1bQV4mTHJwZAAAP0-RADRY688.png "title=" garbled. png "alt=" Wkiol1bqv4mthjwzaaap0-radry688.png "/>
   

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

2. After viewing the relevant data on the Internet, you need to set the Nls_lang to match the character set of the Oracle server side.

[email protected] ~]$ echo $NLS _lang

American_america. Zhs16gbk

sql> col parameter for A30

Sql> col value for A30

Sql> SELECT * from nls_database_parameters where parameter in (' Nls_language ', ' nls_territory ', ' nls_characterset ');

PARAMETER VALUE

------------------------------ ------------------------------

Nls_language AMERICAN

Nls_territory AMERICA

Nls_characterset Al32utf8

Stitching Nls_language, Nls_territory, nls_characterset three parameters corresponding to the value values is required to set the value of the Nls_lang, that is,

Nls_lang=american_america. Al32utf8

The Nls_lang does not match the target value, so the Nls_lang value needs to be re-exported, i.e.

[email protected] ~]$ export Nls_lang=american_america. Al32utf8

Re-enter the above error operation, the normal display of Chinese error information.

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= "http ://s2.51cto.com/wyfs02/m02/7c/75/wkiom1bqvyyrzjcfaaas24m0xf8898.png "title=" normal. png "alt=" Wkiom1bqvyyrzjcfaaas24m0xf8898.png "/>

The problem of Sqlplus Chinese characters