XML Data Retrieval as VARCHAR or CLOB Data Type - 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ā„¢

XML values can be serialized to a character string and returned as values of VARCHAR or CLOB data types. This serialization can be used with any XML value such as documents, sequences, or atomic values.

The serialization of a document is its well-formed string representation. For a sequence, this is the serialization of its items with intervening white space. For atomic values, it is the canonical lexical representations of those values as described by the XML schema specification.

Values serialized in this fashion are returned to the client encoded in the session character set. If any of the characters cannot be represented in the session character set, an error is raised.