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

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

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