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

Teradata Vantage™ XML Data Type

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
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.