XML Data Loading as VARCHAR or CLOB Data Type

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

The content is expected to be a well-formed XML document (a document node with a single child element) in its character string representation. Attempts to load a document that is not well-formed results in an error.

When loading the document as a VARCHAR or CLOB, the driver encodes the document in the session character set. The constructors of XML type values from VARCHAR or CLOB transcodes this to Unicode (UTF-8) and ignores the encoding specified in the XML declaration.