Supported Language Data Types | Database Design | Teradata Vantage - 17.10 - XML/XMLTYPE Data Type - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kko1591750222108.ditamap
dita:ditavalPath
kko1591750222108.ditaval
Syntax Inline Storage Maximum Length LOB/Non-LOB
XML 4,046 bytes 2,097,088,000 bytes LOB
XML(n) where n <= 64,000 n bytes n bytes Non-LOB
XML(n) where n > 64,000 4,046 bytes n bytes LOB
XML(n) INLINE LENGTH m m bytes n bytes

If n <= m, Non-LOB

Otherwise, LOB

XML data can be stored inline (inside a row) or outside the row in a LOB subtable or both, depending on the syntax used to specify it.

XML and XMLTYPE are synonyms.

For more information on the XML data type, see Teradata Vantageā„¢ - XML Data Type, B035-1140.