Double encoding?   

I am generating an XML in my SP in SQL 2005.
One of the columns in the table is called Title and has a value Eng¡ne Åir—
However, in the final XML I get the above as:
Eng¡ne Åir— (the & got replaced by &)

Is there a way to prevent this double encoding?

date: Mon, 16 Jun 2008 10:23:00 -0700   author:   Gaurav

Re: Double encoding?   

"Gaurav"  wrote in message
news:313A2633-0941-4714-A585-E1787B01658A@microsoft.com...
> I am generating an XML in my SP in SQL 2005.
> One of the columns in the table is called Title and has a value Eng¡ne
Åir-
> However, in the final XML I get the above as:
> Eng¡ne Åir— (the & got replaced by &)
>
> Is there a way to prevent this double encoding?

You've not given us a lot to go on.  First thing to check is that the data
in field isn't already encoded once.

Other than that we'd need to see some code to get an idea of where the
double encoding is coming from.



-- 
Anthony Jones - MVP ASP/ASP.NET

date: Mon, 16 Jun 2008 21:24:13 +0100   author:   Anthony Jones