Accented characters in Program Window

[Grisa]

I use pl/sql developer ver. 10.0.5.1710. When I open a package spec & body in program window all the accented characters (Hungarian characters) was disappeared. After compiling all these chars has been removed from package. Is it a bug in developer or any of the national settings in oracle home or Windows? My win is Win7 64bit SP1.

Regards,
Miklos

 

[Marco Kalter]

This can happen if the Oracle Client character set or Oracle Server character set is not compatible with the special characters.

Can you go to Help > Support Info and copy the text from the "Info" tab page?

 

[Grisa]

Pls, see below!

Regards,
Miklos

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: HUNGARIAN_HUNGARY.EE8MSWIN1250
NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Marco Kalter]

Thanks. Can you edit the Params.ini file in the PL/SQL Developer installation directory and add the following line?

NLS_LANG=HUNGARIAN_HUNGARY.UTF8

Let me know if this helps.

 

[Grisa]

Hi Marco,

Tahnks for reply, I changed the charset to AL32UTF8 and looks fine. If not I'm gonna do as you replied.

Thanks,
Miklos

 

[vrbcik]

I had to change NLS_NCHAR_CHARACTERSET, and NLS_CHARACTERSET to following:

NLS_LANG=AMERICAN_AMERICA.EE8MSWIN1250
NLS_CHARACTERSET=EE8MSWIN1250
NLS_NCHAR_CHARACTERSET=AL16UTF16

Otherwise: program window saved UNICODE file, After I have changed same file to SQL Window ("Change to -> SQL Window") and saved, it was not unicode.