in reply to How to remove the rubbish from "United Kingdom"

The encoding is normally specified at the start of the XML document:
<?xml version="1.0" encoding="windows-1252"?> or <?xml version="1.0" encoding="UTF-8"?>
It is also possible the field in your database table does not save characters in the same format as the xml document. On some databases there is a default character storage setting.
A Monk aims to give answers to those who have none, and to learn from those who know more.