MS SQL XML - Re: 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

Re: British pound sign (£) in xml causes error

McGeeky

2005-07-13, 7:23 am

I have found a work around. I don't know if this is the correct approach
though (feedback welcome). I add a directive to the generated XML file from
the for xml explicit to specify the encoding as follows:

<?xml version="1.0" encoding="ISO-8859-1"?>

This seems to fix the problem

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

"McGeeky" <anon@anon.com> wrote in message
news:%23MdxCE4hFHA.320@TK2MSFTNGP09.phx.gbl...
> 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