JSON Default Values for INLINE LENGTH - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

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 nonLOB 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 nonLOB.

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 nonLOB
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
  • If n = m, then nonLOB
  • If n > m, then LOB
  • If n < m, then error
JSON(n) CHARACTER SET UNICODE, where n ≤ 32000 n characters (default) n characters nonLOB
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
  • If n = m, then nonLOB
  • If n > m, then LOB
  • If n < m, then error
JSON(n) STORAGE FORMAT BSON, where n ≤ 64000 n bytes (default) n bytes nonLOB
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
  • If n = m, then nonLOB
  • If n > m, then LOB
  • If n < m, then error
JSON(n) STORAGE FORMAT UBJSON, where n ≤ 64000 n bytes (default) n bytes nonLOB
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
  • If n = m, then nonLOB
  • If n > m, then LOB
  • If n < m, then error