UTF8 XML parsing error - "illegal xml character" while parsing £

• Praxo

  Mr or Mrs. 500

  Points: 532

  More actions

  January 31, 2011 at 4:51 am

  #232911

  XML parsing: line 1, character 105, illegal xml character

  I have a UTF 8 XML where I am passing £ as data in it. sp_xml_preparedocument is giving me error "illegal xml character" while parsing £.

  When I open the XML in browser it is also giving me error.

  when I open the XML in some editior (visiual studio) I see � charater instead of the pound.

  In this editior if I replace this chanarater with £, it works ok for browser but still a probelm in SQL.

  I am not quite sure if SQL 2005 supports the UTF8 XMLs containing £?

  Appreciate any help on this issue. Thanks.

• bmwendwa

  SSC-Addicted

  Points: 472

  More actions

  February 11, 2011 at 3:09 pm

  #1285927

  Change the encoding from UTF-8 to iso-8859-1 (<?xml version="1.0" encoding="iso-8859-1"?>). That should do the trick.

  Ben