JSON Minimum Values for INLINE LENGTH

Teradata Vantageā„¢ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-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 JSON data type.

Data Type NonLOB Type

Minimum INLINE LENGTH

LOB Type

Minimum INLINE LENGTH

JSON CHARACTER SET LATIN 2 characters 100 characters
JSON CHARACTER SET UNICODE 2 characters 50 characters
JSON STORAGE FORMAT BSON 2 bytes 100 bytes
JSON STORAGE FORMAT UBJSON 2 bytes 100 bytes