JSON Maximum Values for INLINE LENGTH - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
gzn1554761068186.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantageā„¢
The maximum INLINE LENGTH that can be specified is 64000 bytes or the equivalent as shown in this table.
Data Type Maximum INLINE LENGTH
JSON CHARACTER SET LATIN 64000 characters
JSON CHARACTER SET UNICODE 32000 characters
JSON STORAGE FORMAT BSON 64000 bytes
JSON STORAGE FORMAT UBJSON 64000 bytes

Note that the inline length cannot be larger than the maximum length specified for the JSON type.