MS SQL XML - British pound sign (£) in xml causes error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

British pound sign (£) in xml causes error

McGeeky

2005-07-13, 3:23 am

Hi,

I am creating xml using for xml explicit. Some of the data contains the
British pound sign £. When later processing the xml I get errors about an
invalid character in the xml - its the pound sign. Why does for xml explicit
not escape it like it has done with other illegal characters? What is the
best way to deal with the pound signs?

Thanks

--
McGeeky
http://mcgeeky.blogspot.com

Sponsored Links