Oracle Client Language garbled

After the local Oracle connection is created, the default is the GBK character set, if the connection server is not the same GBK character set will appear in Chinese garbled problem, this situation we need to modify the local character set to match the server.

modifying through the registry
Hkey_local_machine/software/oracle/home0
Nls_lang change to the character set you want.

Setting environment variables

Add environment variable---Nls_lang to the character set you want

Common character Sets
American_america. We8iso8859p1
Simplified Chinese_china. Zhs16gbk
American_america. Al32utf8

Simplified Chinese_china. Us7ascii

American_america. Us7scii
AMERICAN _ AMERICA. Zhs16gbk

American_america.utf8

　Now, introduce some of the Nls_lang parameters related to the character set,
Nls_lang format:
Nls_lang = Language_territory.charset
There are three components (language, geography, and character set), each of which controls the characteristics of the NLS subset. Where: language Specifies the language of the server message.
territory specifies the date and number format for the server.
CharSet specifying a character set
For example:
American_america. Us7scii
AMERICAN _ AMERICA. Zhs16gbk
There are also subsets that define the Nls_lang parameter more clearly:
DICT. Base data dictionary base table version
Dbtimezone Database Time Zone
Nls_language language
Nls_territory Region
Nls_currency Local currency characters
Nls_iso_currency ISO Currency character
Nls_numeric_characters small number symbol and component separated
Nls_characterset Character Set
Nls_calendar Calendar System
Nls_date_format the default date format
Nls_date_language Default Date language
Nls_sort character sort sequence
Nls_time_format Time Format
Nls_timestamp_format timestamp format

This article from "There is nothing, know in Providence" blog, please be sure to keep this source http://yangsj.blog.51cto.com/8702844/1697075

Oracle Client Language garbled