UTF-8 characters not supported in XML large data editor

[Marcel Hoefs]

Are UTF-8 characters supported in XML data in de large data editor? I am unabled to display these characters correctly:

Settings:

• PL/SQL Dev. version: 12.0.3.1821
• NLS_LANG: DUTCH_THE NETHERLANDS.UTF8
• NLS_CHARACTERSET: AL32UTF8
• Preference: Unicode enabled is checked
• Grid font: Consolas, script Western
• Editor font: Consolas, script Western

Using these settings I get:

I have highlighted in yellow the string containing UTF-8 characters. These characters are displayed correctly in the upper SQL editor and in the middle data grid. However in the lower XML large data editor these UTF-8 characters are "translated" to something else.

So, what am I missing to get the UTF-8 characters displayed correctly in the large data editor as well?

 

[Marco Kalter]

Can you send me the SQL script to reproduce this?

 

[Marcel Hoefs]

Hi Marco,

This is the query to reproduce the UTF8 character problem in the large data editor:

select xmlcast(xmlquery('$b/Dummy/Name' passing t.xml_message as "b" returning content) as varchar2(100)) name
,      t.*
from   (select xmlelement("Dummy",xmlelement("Name",'Mě

 

[Marco Kalter]

It's truncated. Can you send it by e-mail?

 

[Marcel Hoefs]

Hi Marco,

I have send you my testcase at support@allroundautomations.com

 

[Marco Kalter]

We were able to reproduce and fix this. The fix is included in the 12.0.4 pre-release.