17.10 - XML Data Loading as VARCHAR or CLOB Data Type - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.