Solve the problem of Plsql encountered garbled _oracle

See if there are any differences between the amount of the database server and the client's character set:

Copy Code code as follows:

SELECT * from Nls_database_parameters;
SELECT * from Nls_instance_parameters;
SELECT * from V$nls_parameters t where T.parameter = ' nls_language ' or t.parameter = ' nls_characterset ';
SELECT * from Nls_session_parameters;

1. Set Local client encoding:

Enter My computer, attributes, advanced, environment variables, add 2 items:
Lang=zh_cn. GBK
nls_lang= "Simplified Chinese_china. ZHS16GBK "

2. A more direct approach is to create a TXT file under the Plsql installation file

Copy Code code as follows:

Set Nls_lang=simplified Chinese_china. Zhs16gbk
PLSQLDev.exe

Then rename the bat executable. Configure the Nls_lang above to the plsql.