OceanBase Database supports JSON (JavaScript Object Notation) data types that conform to the RFC 7159 standard. You can store semi-structured JSON data and access and modify data in JSON documents.
JSON data types offer the following advantages:
JSON documents stored in JSON columns are automatically validated. Invalid documents will result in errors.
JSON documents stored in JSON columns can be converted into formats that are easier to read and access. When the server needs to read a JSON value stored in binary format, it does not need to parse the value from text.
Semi-structured encoding is supported in MySQL tenants, further reducing storage costs. It allows splitting a JSON data into multiple sub-columns for storage, with each sub-column encoded separately to improve encoding compression rates and reduce the storage space required for the JSON data. For more information, see Create a JSON value and Semi-structured encoding.