Skip to content

JSON Types

imshooter edited this page Oct 24, 2026 · 1 revision

The values of MYSQL_JSON, which MySQL_GetJSONType gives.

Constant Value Meaning
MYSQL_JSON_NONE 0 The value does not exist, the cell is NULL, or it is not JSON.
MYSQL_JSON_NULL 1 null.
MYSQL_JSON_BOOL 2 true or false.
MYSQL_JSON_INT 3 A number without a fraction or an exponent.
MYSQL_JSON_FLOAT 4 A number with a fraction or an exponent, as 1.5 or 1e3.
MYSQL_JSON_STRING 5 A string.
MYSQL_JSON_ARRAY 6 An array.
MYSQL_JSON_OBJECT 7 An object.

See JSON cells.

Clone this wiki locally