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

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.