CDATA and xml data type

In a recent post, it talked about CDATA section and SQL Server xml data type. SQL Server does not preseve the CDATA section in an xml. E.g.:
 

DECLARE

@x xml;

SET

@x = ‘<element><![CDATA[foo & bar]]></element>’;

SELECT

@x

 
The returned xml is:

‘<element>foo &amp; bar</element>’
 
You can see the CDATA seciton is not preseved. The conent is endcoded instead.

SELECT @x.value(‘element[1]’, ‘nvarchar(30)’)

Returns ‘foo & bar’

For more details, check here.

Advertisements
This entry was posted in SQL server 2005. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s