The error description is 'An invalid character was found in text content.'. sp_xml_removedocument: The value supplied

 

This error happened to me when i try to add xml to the SQL server. this is because of i didn't mentioned the proper character set in the XML.

Thus is used following character set definition in the top of the XML. 

<?xml version="1.0" encoding="windows-1252" ?>