Problem with charset encoding

[Kuba]

Hello!
I have problem with charset encoding in plsqldev 6.0. In database charset is set on ISO-8859-2. When I browse table data in Oracle Enterprise Managment Console everything is fine (there is no any strange marks). In plsqldev I get text data in other encoding - it looks like Windows-1250. Is there any method to change it?

 

[Kuba]

Ok, I know now where was the problem. There was enviroment variable 'NLS_LANG' setted on 'polish_poland.ee8iso8859p2'. I removed it and everything is fine. But this is not a good solution. I need this variable for other purposes. I think that in PL/SQL Developer should be option to ignore this variable and possibility to set other encoding. What you think about it?

 

[Marco Kalter]

Oracle Net performs the conversion between the server and client character set. Instead of the registry you can also set an environment variable in a command file:

set nls_lang=american_america.we8iso8859p2
"c:\program files\plsql developer\plsqldev.exe"

Now the character set is limited to the PL/SQL Developer session.