Encoding of Documents For Loading - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ XML Data Type

Teradata Database
Teradata Vantage NewSQL Engine
Programming Reference
An XML parser expects that the document encoding information is provided in one of the following ways:
  • The encoding is declared in the XML declaration
  • External information is provided to the parser. For example, the encoding set is provided through the parser API.

Otherwise, the encoding should be UTF-8 or UTF-16.

When transferring XML values from client to server, the following encoding rules apply.
IF the document is loaded as… THEN the document encoding should be…
text format XML type value UTF-8.
VARCHAR or CLOB the same as the session character set.
BLOB the same as indicated by the XML declaration.