[OT] How to handle non UTF characters in XML

[Ashish Kulkarni]

Hi
I have java class which creates an XML file from SQL resultset,
It works fine in USA, but i am having issues when this process runs in
Germany where they have non UTF characters in there database like ü or á.
How do we handle this kind of situation in XML file, i set the XML file to
be of UTF-8 type,

the java code which creates the XML file is as below

Document document = builder.newDocument();
Element root = (Element) document.createElement(rootElement);
document.appendChild(root);
// create element with ResultSetMetaData Name
Element record = document.createElement(rm.getColumnName(i));

// add text node with the actual value
record.appendChild(document.createTextNode(rs.getString(k));


Ashish