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

U0400030: GaussDB does not support the LONGTEXT 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

By default, UGO converts the LONGTEXT data type to the TEXT data type. This error is reported, indicating that the maximum storage capacity of the LONGTEXT data type of MySQL is 4 GB and that of the TEXT data type of GaussDB is 1 GB. This error is also reported when Support for LONGTEXT is disabled, indicating that GaussDB does not support the LONGTEXT data type. For example:

CREATE TABLE longtext_test(id INT, context LONGTEXT);

Suggestion

Modify Support for LONGTEXT.