XML Default Values for INLINE LENGTH - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1140
lifecycle
previous
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