JSON Type

On this page

The JSON data type stores any valid JavaScript Object Notation data values, including objects, maps, arrays, and nested types. Refer to Using JSON for more information.

Although the JSON type can be declared with a maximum length of up to 4GB, the size of any single JSON value you insert or assign is limited by max_allowed_packet. By default, max_allowed_packet is 100 MB and can be increased to up to 1 GB.

Data Type

Size

Size (Not Null)

JSON

20 bytes + data size

16 bytes + data size

Valid JSON Values

SingleStore accepts any value that conforms to the JSON standard (RFC 8259) as a valid JSON value.

JSON Value Type

Example

Object

{"name":"Alice","age":30}

Array

[1, 2, 3]

String

"hello"

Number

123, 3.14, -1e10

Boolean

true, false

Null

null

Last modified:

Was this article helpful?