Plsql developer inserting Chinese garbled characters

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

Solution One

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,utf-8), then this reason is excluded. Otherwise, the Oracle character set should be reset to support the Chinese character set. Please search by yourself for specific methods.

Solution II

First, confirm that the Oracle character set supports Chinese characters, and then see if the Plsql character set and the Oracle character set are the same, and if the two character sets are different, it will cause the inserted in the Plsql to become garbled in the database. Set the character set of the Plsql developer, Tools->preferences->fonts->main fonts-> character set, such as:

Solution Three

If your plsql does not have the ability to set the Chinese character set, such as my plsql developer10, that can be resolved by setting the environment variable, adding a name to the environment variable called Nls_ The lang value is your Oracle character set (such as simplified Chinese_china. ZHS16GBK) system variables, restart the plsqldeveloper, the problem can be resolved.

Write it in the back.

The key to solving this problem is to understand the meaning of the character set, and the comrades who are not clear about the concept can search by themselves. About modifying the environment variables to solve this problem, involving Oralce on the character set selection of priority issues, interested comrades can be in-depth study.

Plsql developer inserting Chinese garbled characters