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

Teradata Vantageā„¢ - Database Design

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)
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.