If you do not specify an inline length and the maximum length of the data type is 64000 bytes (32000 UNICODE characters) or smaller, the default inline length is the same as the maximum length, and the data type is a non-LOB type.
If you do not specify an inline length and the maximum length of the data type is larger than 64000 bytes (32000 UNICODE characters), the data type is a LOB type with a default inline length as shown in the following table.
This table summarizes possible values for the inline length and the maximum length and whether the data type will be a LOB or non-LOB.
Data Type | Inline Storage | Maximum Length | LOB Type |
---|---|---|---|
XML | 4046 bytes (default) | 2097088000 bytes (default) | LOB |
XML(n), where n <= 64000 | n bytes (default) | n bytes | non-LOB |
XML(n), where n > 64000 | 4046 bytes (default) | n bytes | LOB |
XML(n) INLINE LENGTH m | m bytes | n bytes |
|