Dear,

When running a simple query in SQL window, everything looks OK except that for those with simplified chinese char inside. For those with simplified chinese, they just show something like : 蕞蕞蕞-蕞蕞-蕞蕞-蕞蕞. Any idea how to fix that ? Thx.

Below are the Support Info of my environment:

PL/SQL Developer
Version 9.0.6.1665
116.84760 - 2 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,883,604 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\user1\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\user1\AppData\Roaming\PLSQL Developer\Preferences\user1\default.ini

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
DB1
EXTPROC_CONNECTION_DATA
DB2
DB3

Homes
OraClient11g_home2 (C:\Oracle\product\11.2.0\client_1)

DLLs
C:\Oracle\product\11.2.0\client_1\bin\oci.dll

TNS File
C:\Oracle\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home2
DLL: C:\Oracle\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
Oracle Database 10g Release 10.2.0.4.0

Character Sets
Character size: 2 byte(s)
CharSetID: 852
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: ZHS16GBK
NLS_NCHAR_CHARACTERSET: AL16UTF16

The problem is caused by the character set of your NLS_LANG:

NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

You need to change this setting in the Oracle Registry to a compatible Chinese character set or UTF8.

Dear Macro,

In my case, what NLS_LANG should I be used? and where should I change?


Sorry I am a newbie in Oracle and this SQL tools and not sure where to change those change.

Thank you.

You can set it in the Oracle Registry or in params.ini in the PL/SQL Developer installation directory. For example, add the following line to params.ini:

NLS_LANG=AMERICAN_AMERICA.ZHS16GBK