<div>
This worked. Substituting the different encoding (Windows-1252) for UTF-8 worked without a hitch. A BIG thanks!
</div>


This worked. Substituting the different encoding (Windows-1252) for UTF-8 worked without a hitch. A BIG thanks!

<div>
<div class="content wysiwyg-content">
I keep getting an error when I try to export my MySQL database to XML file.<br />
<br />
ERROR MESSAGE:<br />
XML Parsing Error: not well-formed<br />
Location: <a href="https://www.intelligencecareers.com/_cs/resumes/xml2011v1/2010.12.29.xml" rel="ugc">https://www.intelligencecareers.com/_cs/resumes/xml2011v1/2010.12.29.xml</a><br />
Line Number 37, Column 6:2003 ¿ 2007<br />
-----^<br />
<br />
The error occurs where the text should read '2003 - 2007'<br />
<br />
Have tried to filter out the FFFD unicode character with:<br />
<br />
&lt;cfset newxml = rereplace(#newxml#, &quot;[\0xfffd]&quot;, &quot;&quot;, &quot;All&quot;)&gt;<br />
and <br />
&lt;cfset newxml = rereplace(#newxml#, &quot;[\0x2013]&quot;, &quot;&quot;, &quot;All&quot;)&gt;<br />
<br />
My unicode editor shows the offending charactoer to be U+2013<br />
<br />
My XML page is set to UTF-8 but this and other characters keep appearing.<br />
<br />
How do I filter out these higher unicode characters, and specfically FFFD or U+2013?
</div>
</div>


I keep getting an error when I try to export my MySQL database to XML file.

ERROR MESSAGE:
XML Parsing Error: not well-formed
Location: https://www.intelligencecareers.com/_cs/resumes/xml2011v1/2010.12.29.xml
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")>
and 
<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?

Coldfusion XML String Replace FFFD Unicode character

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).