U0400002: The GaussDB table attribute does not support this collation
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 Distributed
Syntax Example
This error is reported because UGO does not convert the MySQL collation by default.
Different GaussDB versions support different character sets. A collation is a set of rules for comparing characters in a character set. For example, the following collation is not supported in GaussDB V2.0-8.0.
CREATE TABLE collate_demo(id INT, name VARCHAR(64)) COLLATE utf8mb3_general_ci;
Suggestion
Modify Support for COLLATE. You can comment out all collation rules or only the collation rules that are not supported by GaussDB. GaussDB supports the collation rules, but whether table-level character sets conflict with database-level character sets remains uncertain.
When initializing the GaussDB database, specify a character set compatible with the source database character set. During the migration, comment out all character sets and collations in the CREATE TABLE statement and use the default character set and collation of the GaussDB database. If the character set and collation in the original table is inconsistent with those in the database, you need to evaluate the risk and impact. For more information about the GaussDB collation, see GaussDB Developer Guide.
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.
For any further questions, feel free to contact us through the chatbot.
Chatbot