OceanBase Database supports the JSON (JavaScript Object Notation) data type defined in the ECMA-404 and IETF RFC 8259 standards. According to the JSON standard, a JSON value can be an object, an array, a number, a string, a boolean value (true or false), or null. These values are all JSON language data types. Scalar values are all values except objects and arrays.
In JSON, each attribute name and each string value must be enclosed in double quotation marks (").
A JSON string consists of Unicode characters, with backslashes () used for escaping. JSON numbers are represented in decimal form. Object attributes are often referred to as fields, and the name-value pairs of an object are typically called object members (though members can also refer to attributes). JSON array elements are enclosed in brackets ([, ]) and can be objects, arrays, or scalar values. Elements are separated by commas (,), and the order of array elements is important.
In addition to JSON data types, a set of SQL functions can be used to create, query, and modify JSON values. For more information, see JSON functions.