15.00 - JSON Data Type - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

JSON Data Type

The JSON type stores data in an optimized format, depending on data size:

 

Column Size

Storage Location

≤ 64 KB (64,000 LATIN characters or 32,000 UNICODE characters)

All rows are stored in the table.

≥ 64 KB (64,000 LATIN characters or 32,000 UNICODE characters)

Storage depends on the JSON data size:

  • JSON data < 4 KB (4,096 bytes) is stored in the table.
  • JSON data > 4 KB (4,096 bytes) is stored in a LOB subtable.
  • A table may have some JSON data rows stored in the base table and other JSON data rows stored in a LOB subtable.

    If there is no column length specified, the default length is the maximum for the character set in use.

    The JSON type has the same storage properties and limitations as the CLOB data type, except the maximum total size is 16 MB (16,776,192 LATIN characters and 8,388,096 UNICODE characters).“Character Data Types” on page 840 documents the properties of the CLOB data type.