开发者

SQL XML Column displaying squares as nodes

开发者 https://www.devze.com 2023-01-27 16:15 出处:网络
for some reason, my xml column in the SQL database is showing squares as the nodes. I\'m not sure where this is.

for some reason, my xml column in the SQL database is showing squares as the nodes. I'm not sure where this is.

the XML is well formed. It is an object serialized from .NET.

any help would be great.

Sample from the Column:

SQL XML Column displaying squares as nodes

The XML that is saved looks like this:

<Details>
    <Attribute Type="o">1000</Attribute>
    <Attribute Type="f">1000</Attribute>
    <Attribute Type="f">2000</Attribute>
  </Details>

The .NET code that serializes the object is:

this.Serialize(typeof(Details))

I am removing the following line f开发者_StackOverflow社区rom the XML string:

<?xml version=\"1.0\" encoding=\"utf-16\"?>


What is the exact table definition? And also the exact code you use in .Net, including the serializer type and the SQL parameters types used. Is the Detail_XML_Package column of type XML, or is it some VARCHAR column?

That data looks like a bad encoding, like if the XML serializer is saving an Unicode stream and the column is ASCII.

0

精彩评论

暂无评论...
验证码 换一张
取 消