Oracle 10g sqlplus, pl SQL developer, character Chinese garbled Solution

After Oracle 10 Gb is installed, a table is created to write Chinese data. It is found that the PL/SQL developer tool cannot display Chinese normally.

To display Chinese characters properly, the server must be consistent with the client encoding. Therefore, check.

1. Check the server code:

Execute SQL Syntax:

Select * from V $ nls_parameters;

 

 

You can also set it in the/home/Oracle/. bash_profile language.
You can see that my related settings are:

Lang = zh_cn.gbk
Nls_lang = "simplified chinese_china.zhs16gbk"

 

2. Set the local client encoding:

Enter my computer, properties, advanced, environment variables, and add two items:

Lang = zh_cn.gbk
Nls_lang = "simplified chinese_china.zhs16gbk"

 

:

3. Reconnect sqlplus to view the data:

 

Display normal.

4. Set and reconnect PL/SQL developer:

In the menu of PL/SQL developer-> Tools-> preferences-> User Interface-> fonts, modify the font to a Chinese font.

Reconnect ,:

Display normal. OK!