XML data type

The XML data type stores character data of arbitrary length, and is used to store XML documents.

Syntax

XML

Remarks

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.

See also
Standards and compatibility
  • SQL/2003   Compatible with SQL/2003.