Updated on 2025-06-30 GMT+08:00

JSON Data Type

Table 1 JSON data type

MySQL

GaussDB

Difference

JSON

Supported, with differences

  • The JSON types in GaussDB in MYSQL-compatible mode are the same as the native JSON type of GaussDB but greatly different from that of MySQL. Therefore, the JSON types are not listed one by one.
  • For details about the JSON types in GaussDB in MYSQL-compatible mode, see "SQL Reference > Data Types > JSON/JSONB Types" in Developer Guide.