Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Double encoding?
1 view
Skip to first unread message
Gaurav
Jun 16, 2008, 1:23:00 PM6/16/08
to
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 &)
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?
Anthony Jones
Jun 16, 2008, 4:24:13 PM6/16/08
to
"Gaurav" <Gau...@discussions.microsoft.com> wrote in message
news:313A2633-0941-4714...@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?
news:313A2633-0941-4714...@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
> 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
0 new messages