Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from MySQL to GaussDB/ U0400031: GaussDB does not support the LONGBLOB data type
Updated on 2025-06-07 GMT+08:00
View PDF
Share

U0400031: GaussDB does not support the LONGBLOB 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 (B-compatible mode) V2.0-3.2 and earlier

Syntax Example

This error is reported because UGO does not convert the LONGBLOB data type by default, indicating that GaussDB does not support the LONGBLOB data type. This error message is also displayed when Support for LONGBLOB is set to BLOB. During migration to GaussDB Centralized, a message is displayed, indicating that a maximum of 32 TB of data can be stored for the BLOB data type in a GaussDB database. However, in a MySQL database, a maximum of 4 GB of data can be stored for the LONGBLOB data type. After migration to GaussDB Distributed, a message is displayed, indicating that a maximum of 1 GB of data can be stored for the BLOB data type in the GaussDB database, and a maximum of 4 GB of data can be stored for the LONGBLOB data type in the MySQL database. For example:

CREATE TABLE longblob_test(id INT, context LONGBLOB);

Suggestion

Modify Support for LONGBLOB.