Encoding of Documents For Loading - 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™
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.