XML parsing - characters not shown properly

rigosong — Mon, 22 Mar 2021 15:05:27 GMT

Hello,

I'm reading XML data directly from an Oracle DB BLOB field which is working fine except that certain characters are not parsed properly. The word "Qualität" for example is parsed as "QualitÃ¤t".

From what I can tell all the XMLs have prober encoding defined, see below:

<?xml version="1.0" encoding="UTF-8"?>

When loading the XML data I tried to enforce UTF-8 encoding but unfortunately it didn't help. Characters are still not shown correctly. Code:

LOAD * From_Field (xml,data) (utf8,XmlSimple, Table is ...)

Any ideas what the problem might be?

Thanks!

topic XML parsing - characters not shown properly in QlikView

XML parsing - characters not shown properly