16.20 - XML Default Values for INLINE LENGTH - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

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

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 nonLOB
XML(n), where n > 64000 4046 bytes (default) n bytes LOB
XML(n) INLINE LENGTH m m bytes n bytes
  • If n = m, then nonLOB
  • If n > m, then LOB
  • If n < m, then error