Plsql setting the displayed character set and setting

I. About PLSQL cannot display Chinese correctly

Just download installed Plsql Developer 9.0.0.1601 green version, execute SQL query statement, found that the displayed data as long as the Chinese will be? Said. After the online query that this is the client and the server character set mismatch caused. Here's how to fix it:
1. Query the Oracle server-side character set. Open the Plsql Query window and enter the following SQL query statement.
Select Userenv (' language ') from dual;

The resulting server character set is: Simplified Chinese_china. Zhs16gbk
2, My Computer environment variable interface, in the system variable added:
Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk
The value of the variable is consistent with the value queried by the server.

This setting steps to know that this setting is not only for plsql, all the Chinese when connecting to Oracle on the customer service machine must be set by this method the character set and the consistent party on the server can display Chinese content correctly.

Second, Plsql Green Chinese version of the software set in Chinese display

In Plsql click the menu tools--preferences in the popup settings window to find appearance--language Select Simplified Chinese.

Plsql when logging in, the database contents in the Login window should be set

This place plsql will actually read a file, the full path of the file is: The Oracle Customer service is located in the directory App\administrator\product\11.2.0\client_1\network\admin\tnsnames.ora

If my Oracle client is installed on drive D, then D:\app\Administrator\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Plsql setting the displayed character set and setting