Share via


2.1.2.52 [ISO/IEC9075-14:2011] X074, XMLSerialize: BLOB serialization and DOCUMENT option

V0087:

The specification states the following:

 Subclause 6.8, "<string value function>": 
  
 Without Feature X074, "XMLSerialize: BLOB serialization and DOCUMENT option", conforming SQL language shall not contain an <XML binary string serialization> that immediately contains a <document or content> that is DOCUMENT.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature. See the CAST and CONVERT functions [MSDN-Transact-SQLRef] for equivalent functionality. The CAST and CONVERT functions support serializing from XML(DOCUMENT) to BLOB (VARBINARY). A byte-order mark will be added.

This variation pertains to XML parser functionality in SQL Server.