XML data type values include:
- XML documents.
- Non-well-formed text entities, including XML document fragments, such as sequences.
- XML schema predefined simple type values, such as atomic values.
The Teradata Database XML data type is available in ODBC if supported by the database. The XML data type is shown in ODBC as a Teradata-defined SQL type named SQL_TD_XML.
The name SQL_TD_XML is defined in the tdsql.h file. For information, see Teradata Extensions to the ODBC Standard.
LOB support should not be disabled when using XML data types. LOB support is enabled by default and the option to disable LOB support is deprecated.