in reply to single quotes in XML values

The quote in the text should not cause any trouble. A quote could only be a problem if within an attribute quoted qith the same quote (as in <desc long='Second Row Captain's Chairs'...).

This looks very much like an encoding problem to me. If you don't specify the encoding, it is assumed to be UTF-8 (or possibly UTF-16). Are you sure it is? Did you post the original data? Maybe what you think is a ' is in fact some other character, which would not be in UTF-8? Windows is notorious for using non-standard encodings, of which I know nothing, so if that's where the data is created you might want to look into that. Otherwise for example ʼ (Char 00700 | U+2bc | modifier letter apostrophe) looks suspiciously like a single quote but is not. Other suspects: ′ (I an sure you had recognized Char 08242 | U+2032 | prime), ’ (the famous Char 08217 | U+2019 | right single quotation mark).

BTW, I used Sean Burke's excellent Unicode Sliderule to find this character.