XML Default Values for INLINE LENGTH - Analytics Database - Teradata Vantage

XML Data Type

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
lifecycle
latest
Product Category
Teradata Vantageā„¢

If you do not specify an inline length and the maximum length of the data type is 64000 bytes (32000 UNICODE characters) or smaller, the default inline length is the same as the maximum length, and the data type is a non-LOB type.

If you do not specify an inline length and the maximum length of the data type is larger than 64000 bytes (32000 UNICODE characters), the data type is a LOB type with a default inline length as shown in the following table.

This table summarizes possible values for the inline length and the maximum length and whether the data type will be a LOB or non-LOB.

Data Type Inline Storage Maximum Length LOB Type
XML 4046 bytes (default) 2097088000 bytes (default) LOB
XML(n), where n <= 64000 n bytes (default) n bytes non-LOB
XML(n), where n > 64000 4046 bytes (default) n bytes LOB
XML(n) INLINE LENGTH m m bytes n bytes
  • If n = m, then non-LOB
  • If n > m, then LOB
  • If n < m, then error