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

Michael Rys [MSFT]

2005-07-14, 3:23 am

You may also want to write N'£' in your select clause instead of just '£' to
make sure that SQL Server does treat the character correctly.

BTW, in SQL Server 2005, this works.

Best regards
Michael

"McGeeky" <anon@anon.com> wrote in message
news:OR91nC5hFHA.1788@TK2MSFTNGP12.phx.gbl...
>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...
>
>

Sponsored Links