how do I get the ampersand character back?

[David Bartosik [MSFT MVP]]

I'm parsing an XML file with XMLDocument, each node I write to SQL server.

Sometimes values in the XML have to contain an ampersand, so they are in the
XML as & obviously.

I assumed the .net framework took care of converting & back to &

But I'm wrong in that assumption.

For every & in the XML I receive

&

in the SQL Server data.

What am I needing to do to restore that & character?

David Bartosik
Microsoft MVP

[Kevin Yu [MSFT]]

Hi David,

As far as I know, when you load the Xml data into the XmlDocument class,
the & will be converted to & automatically. This is the default
decoding. Will that be encoded again when data writes to SQL server? Please
check this in XmlDocument in local memory first. If that is not the case,
could you paste your code here?

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Martin Honnen]

David Bartosik [MSFT MVP] wrote:

I'm parsing an XML file with XMLDocument, each node I write to SQL server. For every & in the XML I receive

&

in the SQL Server data.

What exactly are you doing to write data in the XmlDocument to the data
base?

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[David Bartosik [MSFT MVP]]

I posted it at www.davidbartosik.com/snippet.txt
It's verbatim minus the actual xml file name.

David Bartosik
Microsoft MVP

What exactly are you doing to write data in the XmlDocument to the data
base?

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[David Bartosik [MSFT MVP]]

I'm pretty sure I've written actual "&" to sql server before and not seen it
converted. If you didn't catch it in my post, what I find really odd is that
it's not the original & in the xml going into the sql table field, the
value is
&
My schedule the next couple of days won't afford me a chance to debug this,
thanx for telling me what to check, hopefully I can get back to it first of
the week. While I'm working on another project seemed like a good time to
multi-task this inquiry ;-)
I did post a code snippet, see my other response post.

David Bartosik
Microsoft MVP

"Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
news:U0**************@TK2MSFTNGXA02.phx.gbl...

Hi David,

As far as I know, when you load the Xml data into the XmlDocument class,
the &amp; will be converted to & automatically. This is the default
decoding. Will that be encoded again when data writes to SQL server?
Please
check this in XmlDocument in local memory first. If that is not the case,
could you paste your code here?

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Kevin Yu [MSFT]]

Hi David,

From the code, I didn't see anything wrong. I tried it on my machine with
inserting & char into a VarChar column, it works fine. Could you show us
the insertItems stored procedure and let me know on which column did the
problem occurs? If you don't have time to debug on it currently, you can
just reply to this post whenever you have time in the future.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."