SQL Developer character set GBK, utf-8, GB2312, ISO - 8859-1, and so on all sorts of forms are not success, strives for the great god give a solution, very grateful ~ ~

CodePudding user response:

Suspicion is that data is garbled, in PLSQL or try with someone else's machine, you see is garbled, or normal Chinese characters;

CodePudding user response:

The code? This is you copy? Knock on your hands?

CodePudding user response:

Need to confirm is the issue of SQL dev tools or a problem with oracle
1, use other tools or up sqlplus showed that the content of the process, to see if normal
2, check the machine or the character of this session, to see if match

 select * from nls_session_parameters 

CodePudding user response:

Right-click on my computer properties - advanced system Settings - senior - environment variable, a new user variable: a variable name: NLS_LANG variable values: SIMPLIFIED CHINESE_CHINA. ZHS16GBK