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