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 Ñ \00E3 \00F8 \4F1A \260E \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