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