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

PLSQL executes the SQL statement, does not recognize Chinese, the output Chinese title is displayed as a question mark????

Tools/Materials

• Plsql Developer 9

Method/Step

2. 1

   Login Plsql, execute the SQL statement, the output of the Chinese title is displayed as a question mark???? If the condition contains Chinese, 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 Simplified Chinese

6. 3

   Go to the registry, click HKEY_LOCAL_MACHINE--->SOFTWARE---> Oracle--->home (the small codec is Oracle 11g, shown here as Key_oradb11g_home1), Locate Nls_lang to see if the value data is: Simplified Chinese_china. Zhs16gbk

8. 4

   If none of the above settings are a problem, look at the settings for the environment variable, see if there is a variable nls_lang, or create a new variable

10. 5

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

12. 6

    Exit Plsql and re-login to Plsql. Input SQL statement, execute, Chinese title finally normal display, also have data output

14. 
    

PLSQL executes the SQL statement, does not recognize Chinese, the output Chinese title is displayed as a question mark????

Tools/Materials

• Plsql Developer 9

Method/Step

2. 1

   Login Plsql, execute the SQL statement, the output of the Chinese title is displayed as a question mark???? If the condition contains Chinese, 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 Simplified Chinese

6. 3

   Go to the registry, click HKEY_LOCAL_MACHINE--->SOFTWARE---> Oracle--->home (the small codec is Oracle 11g, shown here as Key_oradb11g_home1), Locate Nls_lang to see if the value data is: Simplified Chinese_china. Zhs16gbk

8. 4

   If none of the above settings are a problem, look at the settings for the environment variable, see if there is a variable nls_lang, or create a new variable

10. 5

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

12. 6

    Exit Plsql and re-login to Plsql. Input SQL statement, execute, Chinese title finally normal display, also have data output

14. 
    

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