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

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
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 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