Plsql Chinese garbled problem (show question mark)

Problem:

Open Plsql, execute SQL statement, Chinese display garbled:

Https://i.cnblogs.com/EditPosts.aspx?opt=1

Solution:

1) Input SQL statement Select Userenv (' language ') from dual view database character set

2) Enter SQL statement SELECT * from V$nls_parameters view local character set to see if the first and nineth rows correspond

3) Review the settings of the environment variable to see if there is a variable nls_lang, or create a new variable

4) New variable, set variable name: Nls_lang, Variable value: Simplified Chinese_china. ZHS16GBK (the variable value here needs to be the same as the database environment, so it is not fixed: for example, there will be utf-8, etc.), OK

5) Reopen Plsql, execute SQL statement, issue resolution

Plsql Chinese garbled problem (show question mark)