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

U0400036: GaussDB (M-compatible mode) does not support the JSON data type

Description

Database Type and Version

  • Source database type and version: MySQL 5.5, 5.6, 5.7, and 8.0
  • Target database type and version: GaussDB (M-compatible mode) V2.0-8.100

Syntax Example

This error is reported because GaussDB (M-compatible mode) V2.0-8.100 does not support the JSON data type, for example:

create table test_json (
    id int,
    c_json json
);

Suggestion

You can use either of the following methods:

  1. Modify json datatype conversion. After the JSON data type is converted to the TEXT data type, JSON data can be processed only at the service layer.
  2. Upgrade GaussDB to V2.0-8.200 or later. The JSON data type is supported in GaussDB (M-compatible mode).