16.10 - XML/XMLTYPE Data Type - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
User Guide
Publication ID
B035-1094-161K
Language
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 XML (B035-1140).