Coldfusion XML String Replace FFFD Unicode character

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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

The XML file (at least the part of it giving the error) is encoded in the "Windows-1252" codepage,
because the characters which give you the errors belong to that codepage.
(for example, the character on the line 37 is actually a dash with code 0x96).
So, try to change the "encoding" attribute in the XML declaration to "Windows-1252".

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wdgoldenAuthor Commented:
This worked. Substituting the different encoding (Windows-1252) for UTF-8 worked without a hitch. A BIG thanks!
you're welcome
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ColdFusion Language

From novice to tech pro — start learning today.