The solution of the Chinese garbled problem in PL/SQL Developer

Resolved in three steps:

1. Check the server encoding:
Run SQL Syntax: SELECT * FROM V$nls_parameters;

2. Set the local client code:
Enter My computer, properties, advanced, environment variables, add 2 items: LANG=ZH_CN. GBK and nls_lang= "simplified Chinese_china. ZHS16GBK "
Note: Nls_lang is determined by the value of step 1 {nls_language}_{nls_characterset} (different Oracle server settings, different values)



3. PL/SQL Developer set up and connect again:

In the PL/SQL Developer menu->tools->preferences->user interface->fonts, change to Chinese font {GBK2312}

The solution of the Chinese garbled problem in PL/SQL Developer