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!