Encoding of Documents For Loading

Teradata Vantage™ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
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.