Unicode Configuration

[Dave P]

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?

 

[Marco Kalter]

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.

 

[Dave P]

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.

 

[ifernan]

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)

select 'A Ñ ã ø 会 ☎ 🎄' from dual;

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:

select UNISTR('A Ñ ___SNIPPET___E3 ___SNIPPET___F8 F1A 0E \D83C\DF84') from dual;

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

 

[Marco Kalter]

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?

 

[ifernan]

I have attached a file with "Info" tab.
View attachment info.txt

 

[ifernan]

Any news about this?

 

[Marco Kalter]

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?

 

[ifernan]

"Info" when connected attached.
View attachment info.connected.txt

 

[Marco Kalter]

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.

 

[ifernan]

Thanks Marco. With that NLS_LANG everything is working fine. :grin: