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.