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 | Non-LOB 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 |