| 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.