We receive xml documents that contain special ASCII characters that "should be" displayable on an IBM i. For example, the O-Umlaut character Ö. When we parse the xml document using XMLTABLE(), we get the à symbol followed by a question mark inside a box. This is not the only symbol we have this problem with. Some symbols even cause XMLTABLE() to fail parsing. Two questions:
1. How do we get XMLTABLE() to properly parse special characters (like O umlaut)
2. How do we pre-determine which special characters are not parse-able by XMLTABLE()
1. How do we get XMLTABLE() to properly parse special characters (like O umlaut)
2. How do we pre-determine which special characters are not parse-able by XMLTABLE()
Comment