Plsql:[1]plsql Chinese characters, display question mark

Plsql runs the SQL statement and does not recognize Chinese. The output of the Chinese title is displayed as a question mark??

??

Tools/Materials

• Plsql Developer 9

Method/Step

2. 1

   Log in to Plsql and run the SQL statement. The Chinese caption of the output is displayed as a question mark????。 Conditions include Chinese. There is no data output

4. 2

   Enter SQL statement SELECT * FROM V$nls_parameters view character set to see if the first row value value is Chinese Simplified

   picindex=2 "target=" _self "style=" Background-color:inherit; Color:rgb (45,100,179) ">

6. 3

   Go to the Registration form, click HKEY_LOCAL_MACHINE--->SOFTWARE---> Oracle--->home (the small codec is Oracle 11g. Shown here as Key_oradb11g_home1), find Nls_lang and see if the value data is: Simplified Chinese_china. Zhs16gbk

8. 4

   Assuming that none of the above settings are a problem, look at the settings for the environment variables below. See if there are variable Nls_lang. No, the variable is created

   Picindex=5 "target=" _self "style=" Background-color:inherit; Color:rgb (45,100,179) ">

10. 5

    Creates a new variable. Set Variable name: Nls_lang. Variable value: Simplified Chinese_china. ZHS16GBK, make sure you can.

    Picindex=7 "target=" _self "style=" Background-color:inherit; Color:rgb (45,100,179) ">

12. 6

    Exit Plsql. Once again landed Plsql. Enter the SQL statement. Run, the Chinese title finally normal display, also has the data output

14. 
    

Plsql runs the SQL statement and does not recognize Chinese. The Chinese caption of the output is displayed as a question mark???

?

Tools/Materials

• Plsql Developer 9

Method/Step

2. 1

   Login plsql, run the SQL statement, the output of the Chinese title is displayed as a question mark???

   ?; conditions include Chinese, no data output

4. 2

   Enter the SQL statement SELECT * FROM v$nls_parameters to view the character set. View first row value value is Chinese Simplified

   picindex=2 "target=" _self "style=" Background-color:inherit; Color:rgb (45,100,179) ">

6. 3

   Enter the registration form. Click HKEY_LOCAL_MACHINE--->SOFTWARE---> Oracle--->home (Small codec installed Oracle 11g, shown here as Key_oradb11g_home1), find Nls_ Lang. See if the value data is: Simplified Chinese_china. Zhs16gbk

8. 4

   Assuming that none of the above settings are a problem, look at the settings for the environment variable and see if there is a variable Nls_lang. No, the variable is created

   Picindex=5 "target=" _self "style=" Background-color:inherit; Color:rgb (45,100,179) ">

   Picindex=6 "target=" _self "style=" Background-color:inherit; Color:rgb (45,100,179) ">

10. 5

    New variable, set variable name: Nls_lang. Variable value: Simplified Chinese_china. ZHS16GBK. OK, you can.

    Picindex=7 "target=" _self "style=" Background-color:inherit; Color:rgb (45,100,179) ">

12. 6

    Exit Plsql. Once again landed Plsql. Enter the SQL statement. Run, the Chinese title finally normal display, also has the data output

    Picindex=8 "target=" _self "style=" Background-color:inherit; Color:rgb (45,100,179) ">

14. 
    

Plsql:[1]plsql Chinese characters, display question mark