Problem
These two days have just configured plsql with Oracle , but when inserting data in Plsql. There is a problem, the table in Plsql cannot display Chinese, Chinese cannot be saved, cannot be exported. Chinese displays question marks in the table.
Reason
After some verification, we find that the source of the problem is not on Today 's plsql , but on our Oracle , because our the character set in the Oracle database does not support Chinese. Now that I know the reason. It's good to be done. Let's configure our Oracle character set to support Chinese.
How to Solve
my own Oracle is a 11g version number, the following take my example, for everyone to explain the process of setting up.
Step One
Start -Execute-Enter regedit-carriage return to enter the registration form. Click HKEY_LOCAL_MACHINE--->software---> ORACLE--->key_oradb11g_home1 (of different version numbersOraclethe display is not the same, but it will includeHomethis word), locate"Nls_lang"to see if the value data is:"simplified Chinese_china. ZHS16GBK". Suppose you don't set it to "simplified Chinese_china. ZHS16GBK.
”
Step Two
after setting up the registration form, set up our environment variables, computer (right-click)--->Properties--->Advanced system Settings--->Advanced--->Environment Variables--->New. Personal suggestions Create a new user variable. Variable name input: "Nls_lang". Variable value input: "simplified Chinese_china. ZHS16GBK". Click OK to do so. We've set it up by this.
Effect
The following look at our effect, close plsql, another launch, Chinese really appeared,
Postscript
Environment variables let us in the development of the convenience of a lot, but it is also a lot of problems, "the source of evil", the pain and happiness of the environment variables ah.
Oracle uses--plsql's Chinese garbled display is all question marks