XML Minimum and Maximum 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 the data type is not a LOB, then the minimum inline length must be equal to the maximum length specification for the data type.

If the data type is a LOB type (inline length is less than maximum length), the minimum inline length must be at least 100 bytes to accommodate the storage of the LOB OID (Object Identifier).

The following table shows the minimum INLINE LENGTH required for the XML data type.

Data Type NonLOB Type

Minimum INLINE LENGTH

LOB Type

Minimum INLINE LENGTH

XML 100 bytes 100 bytes

The maximum inline length that can be specified is 64000 bytes. In addition, the inline length cannot be larger than the maximum length specified for the XML type.