The Chinese garbled display of Oracle database Plsql is all question marks

Reason:

Xiao sister called me to help her reload the database, so good weekend time not to go out to play, to her to install the database it is not very painful.

I asked her why she had to reload, she said: After the data into the database, Chinese characters are garbled, it must be the last time I installed the database to her

There is a problem. In order to set up a database for her, but the cost of Dickens, 64-bit database, 32-bit database client toss back and forth

Two geniuses are ready, I don't want to get back to her again. Found a solution on the net, all of a sudden the garbled problem solved.

Http://www.2cto.com/database/201407/313317.html

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.

The Chinese garbled display of Oracle database Plsql is all question marks