Plsql developer inserts Chinese garbled characters, plsqldeveloper

Plsql developer inserts Chinese garbled characters, plsqldeveloper

Address: http://yanwushu.sinaapp.com/plsql-developer-chinese-charactereset/

Solution 1

The oracle character set cannot store Chinese characters. The following statement queries the oracle character set.

Selectuserenv ('language') from dual;

If the query results support Chinese characters (such as gbk and UTF-8), this is the reason for troubleshooting. Otherwise, you should reset the oracle character set to a Chinese character set. Please search for specific methods by yourself.

Solution 2

First, confirm that the oracle Character Set supports Chinese characters, and then check whether the plsql character set is the same as the oracle character set. If the two character sets are different, the Chinese characters inserted in plsql will become garbled in the database. Set the character set of plsql developer, tools> preferences> fonts> main fonts> character set, for example:

Solution 3

If your plsql does not have the Chinese Character Set setting function, for example, my plsql limit 10 does not, you can use the environment variable setting method to solve this problem, add a system variable named NLS_LANG to your oracle character set (such as SIMPLIFIED CHINESE_CHINA.ZHS16GBK) to the environment variable and restart plsqldeveloper to solve the problem.

Post

The key to solving this problem lies in understanding the meaning of character sets. comrades who are not clear about this concept can search for it by themselves. How to solve this problem by modifying environment variables involves oralce's priority in character set selection. If you are interested, you can study it in depth.