The problem is that when I landed in the secureCRT tool in Linux database and add a line of Chinese data, query the data in the secureCRT can normal explicitly Chinese, as shown in the figure below:
But to turn to the developer to see explicit gibberish, such as graphic:
Likewise, when in a new Chinese developer data, see explicit in the developer is in Chinese, but to the secureCRT view is gibberish, that is, between the developer and secureCRT can normal explicitly the other input of Chinese data,
In addition, if it is through the VMWare Workstation on Linux and into the oracle, and then a new Chinese data, normal explicitly Chinese in Workstation, and transferred to the explicit Chinese secureCRT view can also be normal, but in the developer explicitly gibberish, and in the secureCRT new Chinese data, the Workstation can normal explicit; Chinese input data in the developer, can't normal explicitly in the Workstation,
Generally speaking, is secureCRT and Workstation explicit properly each other between input of Chinese data, and the developer whether with secureCRT or Workstation explicit properly each other between the input of Chinese data,
So I want to ask you a great god, and how to solve this problem? Actually, as one of the solution I know want to stick to in the end such as developer input and view the data is ok, but I want to know why will appear this kind of situation, and how to correct, hope you some directions! Thank you very much!!!
CodePudding user response:
Take a look at your local environment variable nls_lang this setting, and character set of the CRT software,Should be the same,
CodePudding user response:
See PLSQL clients use do not match the code and the server code, will it a consistent,CodePudding user response:
SecureCRT and Workstation are direct use of the service side, the developer is using your local client, if there is any discrepancy between the character set is garbled wordsCodePudding user response:
See the Oracle character setThe select userenv (" language ") from dual;
To view the registry Orcale character set:
Run - & gt; Regedit - & gt; Sortware - & gt; Oracle - & gt; The value of oraclehome selected to view the NLS_LANG
Whether on a query and are consistent, instead of the same,
CodePudding user response:
You can use this command to select userenv (" language ") from dual; Query Oracle character set, and then in the machine configuration NLS_LANG environment variables: SIMPLIFIED CHINESE_CHINA. ZHS16GBK so many times I have directly with red word variable values to the configuredAnd then restart the PL/SQL