15.10 - JSON Data Type Syntax - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K

Syntax

The following shows the syntax when you use a JSON data type in a data type declaration phrase. For example, this syntax is used when defining a table column to be JSON type.



Syntax Elements

maxlength
A positive integer value that specifies the maximum length of the JSON type as follows:
  • If the storage format of the JSON type is text, the maximum length is in characters. If you do not specify a maximum length, the default maximum length for the character set is used. If specified, the length is subject to a minimum of two characters and cannot be greater than the maximum of 16776192 LATIN characters or 8388096 UNICODE characters.
  • If the storage format is BSON or UBJSON, the maximum length is in bytes. If you do not specify a maximum length, the default maximum length of 16776192 bytes is used.
.
CHARACTER SET
The character set for the JSON type can be LATIN or UNICODE.
If you do not specify a character set, the default character set for the user is used.
You cannot specify CHARACTER SET together with the STORAGE FORMAT clause.
STORAGE FORMAT
Specifies that the storage format of the JSON type will be one of the following binary formats:
  • BSON (Binary JSON)
  • UBJSON (Universal Binary JSON)
If you do not specify a storage format, the default storage format is text in the character set specified (or the default character set).
You cannot specify STORAGE FORMAT together with the CHARACTER SET clause.
attributes
The following data type attributes are supported for the JSON type:
  • NULL and NOT NULL
  • FORMAT
  • TITLE
  • NAMED
  • DEFAULT NULL
  • COMPRESS USING and DECOMPRESS USING

For details on these data type attributes, see SQL Data Types and Literals, B035-1143.