U0400001: The GaussDB table attribute does not support this character set

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: all GaussDB versions

Syntax Example

This error is reported because UGO does not convert MySQL character sets by default.

Different GaussDB versions support different character sets. GaussDB does not allow you to specify character sets that are incompatible with the database, for example:

The gb18030 character set is not supported in GaussDB V2.0-3.2 (B-compatible mode), for example:

CREATE TABLE character_demo(id INT, name VARCHAR(64)) CHARSET gb18030;

A table with the gb18030 character set cannot be created in a distributed GaussDB V2.0-8.0 database with UTF-8 collation, for example:

CREATE DATABASE test DBCOMPATIBILITY = 'MYSQL' ENCODING = 'UTF8';
CREATE TABLE character_demo(id INT, name VARCHAR(64)) CHARSET gb18030;

Suggestion

Modify Support for CHARSET. Comment out all character sets or only the character sets that are not supported by GaussDB (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 in the CREATE TABLE statement and use the default character set of the GaussDB database. If the character set in the original table is inconsistent with that in the database, you need to evaluate the risk and impact. For more information about the GaussDB character set, see GaussDB Developer Guide.