Oracle uses--plsql's Chinese garbled display is all question marks

Problem

These two days just plsql and Oracle configuration, but in the plsql to insert data, there is a problem, the table in Plsql cannot display Chinese, Chinese cannot save, cannot output, Chinese display question mark in the table,

Reason

After some verification, found that the source of the problem is not on the plsql, but on our Oracle, because our Oracle database character set does not support the Chinese cause, since we know the reason, it is good to do, we configure our Oracle character set, let him support Chinese.

Solutions

My Oracle is 11g version, the following take my example, for you to explain the process of setting up.

Step One

Start-run-Enter regedit-carriage Enter the registry, click HKEY_LOCAL_MACHINE--->software---> ORACLE--->key_oradb11g_ HOME1 (Different versions of Oracle display are not the same, but all will contain the word home), find "Nls_lang", to see whether the value data is: "Simplified Chinese_china. ZHS16GBK ", if it is not, set it to" simplified Chinese_china. ZHS16GBK. ”

Step Two

After setting up the registry, set up our environment variables, computer (right-click)---> Properties---> Advanced system settings---> Advanced---> Environment variables---> new, personal suggestions new user variables, variable name input: "Nls_lang", Variable value input: "Simplifiedchinese_china. ZHS16GBK ". Click OK, and we're done here.

Effect

Let's look at our effect, close plsql, restart, Chinese really appear,

Postscript

Environment variables let us in the development of a lot of convenience, but it is also a lot of problems, "the source of evil", the pain and happiness of the environment variables ah.

Original address: http://www.jianfangkk.com/oracle/201601/272

Oracle uses--plsql's Chinese garbled display is all question marks