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
Last Update
2021-07-27
Content Type
User Guide
Publication ID
B035-1094-171K
Language
English (United States)
Last Update
2021-07-27
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.