Question

Invalid XML character

6

I am running into to an issue where my database is full of unicode values that are not supported by the XML importer. Does anyone have a java action that can strip my XML of the invalid characters prior to import? Or does anyone know a better way around this? Updating the database prior to export is not an option and the source data is in AL32UTF-8 format.

asked 2013-01-02

Marc Lehane

4 answers

Pieter van de Braak · Answer 1 · 2013-01-03

Usually the problem is not the fact that you have this character present but rather that the xml document has no or the wrong encoding stated on top. eg. it states encoding="UTF-8" while in reality it is cp-1251

Michel Weststrate · Answer 2 · 2013-01-04

Then your XML states the wrong encoding, UTF-8 != AL32UTF-8. You should update the XML accordingly.

Here someone with the same issue.

Marc Lehane · Answer 3 · 2013-01-03

You are correct, my XML does indeed state "UTF-8". How do I change the encoding? Just renaming it to "CP-1251" or "cp-1251" causes a "Invalid encoding name" error.

Marc Lehane · Answer 4 · 2013-01-04

Would be great, however the modeler tells me that this is an invalid encoding name.