开发者

XML in SQL Server 2005

开发者 https://www.devze.com 2023-01-17 08:11 出处:网络
All, I am inserting as xml datatype in a table, an XSLT document. Somewhere in my XSLT document I am using the character

All,

I am inserting as xml datatype in a table, an XSLT document. Somewhere in my XSLT document I am using the character

< 

for a reason. However when inserting to the table, the SQL Server replaces the

< 

with

<

Any ideas how to store it without having SQL Server to change it?

Thanks,

开发者_如何学GoM


&#60; is the character < and this is the same as &lt;. XML is not a string. Two different representations can encode the same underlying XML and correctly written applications cannot distinguish between them. If your application relies on &#60; to exists in the XML, it cannot be correct.

0

精彩评论

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