I'm hoping I've got a config setting wrong somewhere, but I've been stuck with a client issue, that I've found wasn't the application that I'm supporting. I've boiled it down to the following:

If I run the following SQL from either a SQL or Command window

select 'Ş' from dual;

The results window displays

S

If I run this from Oracle SQL Developer, it displays correctly.

Is there something I need to change to make the display correct?

This indicates that the NLS_LANG for the Oracle Client is either missing, or specifies a character set that is incompatible with the 'Ş' character.

You can go to Preferences > Oracle > Connections, add a new variable, select NLS_LANG, and select a "language_territory.characterset" value that specifies UTF8 for the character set. You will need to restart PL/SQL Developer before this takes effect.

Thanks Marco. I can't find a global setting for the instant client, so I've added it under preferences, and that's fixed the issue.

Hi.

I am working with Unicode characters and using the settings from previous posts in PLSQL Developer 15, overall it works fine. But I found that 4 byte Unicode chars don't always display correctly.

A query like this, that have a 'christmast tree' (4byte Unicode char)


display garbage as output. But If you remove 'christmast tree' the output shows all the characters properly.

Going one step further, executing a query like this (SELECT 1), that returns same characters that the previous one:


Output is showing all the characters properly

But if you copy the value returned and paste as the string of a new SELECT from dual query (SELECT 2), garbage it's displayed again in output. But, incredibly, the header is showing all the characters properly (see images attached).

Regards,
ifernand

Maybe this is an environment problem. Can you start PL/SQL Developer without connecting, go to Help > Support Info and send me the text from the "Info" tab page?

I have attached a file with "Info" tab.

Any news about this?

My apologies, I missed this. And unfortunately my request was not quite correct. Can you send me the "Info" text while connected to this database?

"Info" when connected attached.

Thanks. I see that your NLS_LANG is defined as SPANISH_SPAIN.UTF8. Can you change this to SPANISH_SPAIN.AL32UTF8 and try again? You can make this change through Preferences > Oracle > Connection by adding or changing the NLS_LANG variable under the "Environment Variables" section.

Thanks Marco. With that NLS_LANG everything is working fine.