17.10 - XML Minimum and Maximum 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 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 Non-LOB 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.