2.1.2.53 [ISO/IEC9075-14:2011] X075, XMLSerialize: BLOB serialization

  • Article

V0088:

The specification states the following:

 Subclause 6.8, "<string value function>": 
  
 Without Feature X075, "XMLSerialize: BLOB serialization", conforming SQL language shall not contain an <XML binary string serialization>.

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 both from XML(CONTENT) and from XML(DOCUMENT) to string (either as NVARCHAR or VARCHAR). A byte order mark will be added.

This variation pertains to XML parser functionality in SQL Server.