Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The XML data type stores character data of arbitrary length, and is used to store XML documents.
The maximum size is 2 GB.
Data of type XML is not quoted when generating element content from relational data.
You can cast between the XML data type and any other data type that can be cast to or from a string. Note that there is no
checking that the string is well-formed when it is cast to XML.
For information about using the XML data type when generating XML elements, see Storing XML documents in relational databases.
When an embedded SQL client application performs a DESCRIBE on an XML column, it is described as LONG VARCHAR.
The XML data type is SQL language feature X010 in the SQL/2008 standard.