Why Does the PL/SQL Client Display Garbled Characters During Application O&M?

Symptom

The PL/SQL Developer client for Oracle databases is managed as an application resource. When you attempt to log in to an application resource using a web browser, garbled characters are displayed on the PL/SQL client.

Possible Cause

The encoding format of the Oracle database is different from that of the PL/SQL client, which uses English encoding format. As a result, the PL/SQL client is incompatible with the Oracle database and garbled characters are displayed.

Solutions

1. Query the character set of the Oracle database.

   Run the following command on the PL/SQL client to check the encoding format of the Oracle database:

   select userenv('language') from dual;

   Obtains the default encoding value SIMPLIFIED CHINESE_CHINA.ZHS16GBK.

2. Change the encoding format of the PL/SQL client.

   On the server where the application is published, create the system environment variable NLS_LANG and set its value to SIMPLIFIED CHINESE_CHINA.ZHS16GBK.

3. Restart the PL/SQL client and search for Chinese contents.