Share via


2.1.2.65 [ISO/IEC9075-14:2011] X110, Host language support for XML: VARCHAR mapping

V0100:

The specification states the following:

 Subclause 12.8, "<SQL-invoked routine>":
  
 Without Feature X110, "Host language support for XML: VARCHAR mapping", conforming SQL language shall not contain a <string type option> that contains CHARACTER VARYING, CHAR VARYING, or VARCHAR.
  
 Subclause 18.3, "<embedded SQL C program>":
  
 Without Feature X110, "Host language support for XML: VARCHAR mapping", conforming SQL language shall not contain an <C XML VARCHAR variable>.
  
 Subclause 18.7, "<embedded SQL PL/I program>":
  
 Without Feature X110, "Host language support for XML: VARCHAR mapping", conforming SQL language shall not contain an <PL/I XML VARCHAR variable>.

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

Transact-SQL partially supports this feature. PL/I and C language support is not available.

This variation pertains to xml data type functionality in SQL Server.