Dear forum,

I have an XML file exported from a Web forum running on MySQL. The file has a lot of Unicode characters escaped as HTML codes. How could I import the XML file in a new MySQL database and have all &#nnnn; codes decoded back to Unicode characters?