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 |
---|---|---|---|
JSON | 4096 bytes (default) | 16776192 bytes (default) | LOB |
JSON(n) CHARACTER SET LATIN, where n ≤ 64000 | ncharacters (default) | n characters | non-LOB |
JSON(n) CHARACTER SET LATIN, where n > 64000 | 4096 bytes (default) | n characters | LOB |
JSON(n) CHARACTER SET LATIN INLINE LENGTH m | m characters | n characters |
|
JSON(n) CHARACTER SET UNICODE, where n ≤ 32000 | n characters (default) | n characters | non-LOB |
JSON(n) CHARACTER SET UNICODE, where n > 32000 | 4096 bytes (default) | n characters | LOB |
JSON(n) CHARACTER SET UNICODE INLINE LENGTH m | m characters | n characters |
|
JSON(n) STORAGE FORMAT BSON, where n ≤ 64000 | n bytes (default) | n bytes | non-LOB |
JSON(n) STORAGE FORMAT BSON, where n > 64000 | 4096 bytes (default) | n bytes | LOB |
JSON(n) STORAGE FORMAT BSON INLINE LENGTH m | m bytes | n bytes |
|
JSON(n) STORAGE FORMAT UBJSON, where n ≤ 64000 | n bytes (default) | n bytes | non-LOB |
JSON(n) STORAGE FORMAT UBJSON, where n > 64000 | 4096 bytes (default) | n bytes | LOB |
JSON(n) STORAGE FORMAT UBJSON INLINE LENGTH m | m bytes | n bytes |
|