17.10 - Encoding of Documents For Loading - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
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.