Help Center/
Database and Application Migration UGO/
User Guide/
Syntax Conversion/
Conversion Error Codes/
Error Codes Generated During Conversion from MySQL to GaussDB/
U0400036: GaussDB (M-compatible mode) does not support the JSON data type
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:
- 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.
- Upgrade GaussDB to V2.0-8.200 or later. The JSON data type is supported in GaussDB (M-compatible mode).
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot