CodePudding user response:

The server's character set?

CodePudding user response:

http://blog.csdn.net/yueyeyi1/article/details/9083877

You can take a look at this

CodePudding user response:

Check
1. The client environment variables nls_lang
2. The server database nls_lang
Whether the two corresponding
Query: select userenv (" language ") from dual

CodePudding user response:

The Windows had better use GBK character sets, such as NLS_LANG=SIMPLIFIED CHINESE_CHINA. ZHS16GBK
And local use utf8 Linux character sets, such as the NLS_LANG=SIMPLIFIED CHINESE_CHINA. AL32UTF8

CodePudding user response:

Appears the reason is I the oracle client character set is SIMPLIFIED CHINESE_CHINA. UTF8 I started following a PLSQL mean a page is inconsistent with the character set issues have to do is click ok (normal) but I open the registry changes the NLS_LANG value changed to SIMPLIFIED CHINESE_CHINA. UTF8 and then open the CMD up sqlplus is stil

Repair method is as follows: (that's what I repair)
Run regedit open registry
In the following order to find the
HKEY_LOCL_MACHINE & gt;> SOFTWARE> ORALCE. (if the SOFTWARE can't find the ORACLE went below Wow6432Node find below) & gt;> KEY_ORADB11G_HOME1
The NLS_LANG value is set to SIMPLIFIED CHINESE_CHINA. ZHS16GBK

CodePudding user response:

Check the client and server database environment variable nls_lang Settings

CodePudding user response:

To ZHS16GBK, WINDOWS default encoding is GBK

CodePudding user response:

Should be the problem of character set
Began - run - type regedit - press enter into the registry, in turn, click HKEY_LOCAL_MACHINE - & gt; SOFTWARE - & gt; ORACLE - & gt; KEY_OraDb11g_home1, find "NLS_LANG", check to see if the numerical data for: "SIMPLIFIED CHINESE_CHINA. ZHS16GBK", if not setting it to "SIMPLIFIEDCHINESE_CHINA ZHS16GBK,
"After set the registry, the next set of our environment variable, computer (right) - & gt; Property - & gt; Advanced system Settings - & gt; Advanced - & gt; Environment variable - & gt; New, personal advice new user variable, the variable name input: "NLS_LANG variable values input:" SIMPLIFIED CHINESE_CHINA. ZHS16GBK ", can be determined,

CodePudding user response:

refer to the eighth floor gold osmanthus fragrans response:

should be the problem of character set
Began - run - type regedit - press enter into the registry, in turn, click HKEY_LOCAL_MACHINE - & gt; SOFTWARE - & gt; ORACLE - & gt; KEY_OraDb11g_home1, find "NLS_LANG", check to see if the numerical data for: "SIMPLIFIED CHINESE_CHINA. ZHS16GBK", if not setting it to "SIMPLIFIEDCHINESE_CHINA ZHS16GBK,
"After set the registry, the next set of our environment variable, computer (right) - & gt; Property - & gt; Advanced system Settings - & gt; Advanced - & gt; Environment variable - & gt; New, personal advice new user variable, the variable name input: "NLS_LANG variable values input:" SIMPLIFIED CHINESE_CHINA. ZHS16GBK ", sure can,

Really dig a grave for haha, 8th floor to ah, I just like that, putting the environment variables, back CMD type up sqlplus Chinese shows normal!
How to see the integral...