in reply to What to do when converting Excel-supplied data to Unicode
Well, it's solved well enough for me. I treat the text as CodePage 1252, but before decoding it I fix some special cases such as the dash, a weird apostrophe-type character, and some others. The resulting XML is well-formed, the data in MySQL looks good, and the produced XHTML-strict is valid and compliant. I'm happy with that.
davis
Kids, you tried your hardest, and you failed miserably. The lesson is: Never try.
In Section
Seekers of Perl Wisdom