I keep getting an error when I try to export my MySQL database to XML file.
XML Parsing Error: not well-formed
Line Number 37, Column 6:2003 ¿ 2007
The error occurs where the text should read '2003 - 2007'
Have tried to filter out the FFFD unicode character with:
<cfset newxml = rereplace(#newxml#, "[\0xfffd]", "", "All")>
<cfset newxml = rereplace(#newxml#, "[\0x2013]", "", "All")>
My unicode editor shows the offending charactoer to be U+2013
My XML page is set to UTF-8 but this and other characters keep appearing.
How do I filter out these higher unicode characters, and specfically FFFD or U+2013?