|
|
|
|
|
very worried,very worried,very worried !!! |
|
|
Can you run the following and post the results: Select @@character_set_database Do you have any parameters set such as the db.read.strings.as.bytes parameter? |
|
|
mysql> SHOW VARIABLES LIKE 'character_set_database'; +------------------------+---------+ | Variable_name | Value | +------------------------+---------+ | character_set_database | utf8mb4 | +------------------------+---------+ 1 row in set (0.00 sec) 2、Not set the db.read.strings.as.bytes parameter, it's default value is false. |
|
|
This issue seems to have occurred before, with the number 0002964. |
|
|
Can you run the following and post the results: show table status like 'sym_router'; We'd like to see the table's collation. |
|
|
mysql> desc sym_router; +---------------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------------+--------------+------+-----+---------+-------+ | router_id | varchar(50) | NO | PRI | NULL | | | target_catalog_name | varchar(255) | YES | | NULL | | | target_schema_name | varchar(255) | YES | | NULL | | | target_table_name | varchar(255) | YES | | NULL | | | source_node_group_id | varchar(50) | NO | MUL | NULL | | | target_node_group_id | varchar(50) | NO | | NULL | | | router_type | varchar(50) | NO | | default | | | router_expression | mediumtext | YES | | NULL | | | sync_on_update | smallint | NO | | 1 | | | sync_on_insert | smallint | NO | | 1 | | | sync_on_delete | smallint | NO | | 1 | | | use_source_catalog_schema | smallint | NO | | 1 | | | create_time | datetime | NO | | NULL | | | last_update_by | varchar(50) | YES | | NULL | | | last_update_time | datetime | NO | | NULL | | | description | mediumtext | YES | | NULL | | +---------------------------+--------------+------+-----+---------+-------+ 16 rows in set (0.00 sec) mysql> SHOW TABLE STATUS LIKE 'sym_router'; +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+----------------+---------+ | sym_router | InnoDB | 10 | Dynamic | 3 | 5461 | 16384 | 0 | 16384 | 0 | NULL | 2024-05-29 11:22:28 | NULL | NULL | utf8mb4_bin | NULL | | | +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+----------------+---------+ 1 row in set (0.00 sec) image.png (129,348 bytes) |
|
|
The SymmetricDS tables need to be in the below collation: alter table <some_table> convert to character set utf8mb4 collate utf8mb4_unicode_ci; You could create a DB for SymmetricDS with this collation and install SymmetricDS there. |
|
|
Modified the character and collate set or still reporting an error. ------------------------------------------------------------------------- mysql> SHOW TABLE STATUS LIKE 'sym_router'; +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ | sym_router | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2024-06-06 10:00:56 | NULL | NULL | utf8mb4_unicode_ci | NULL | | | +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ 1 row in set (0.01 sec) image-2.png (262,090 bytes) |
- Anonymous