Insert Special Characters from XML into SQL

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Insert Special Characters from XML into SQL › Insert Special Characters from XML into SQL

March 2, 2006 at 6:38 PM #14401
community-content

    Xml is very specific about character encoding.
    Unless specified otherwise the default encoding is UTF-8.
    <?xml version=\”1.0\” encoding=\”UTF-8\”?>

    You can set the encoding to ISO8259-1 (US-ASCII) on the incoming message
    <?xml version=\”1.0\” encoding=\”ISO-8259-1\”?>

    or possibly use UTF-16 – although this will require changing the data, also using ntext rather than text in SQL