github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/engine/test/integration_tests/dm_collation/data/db2.increment.sql (about)

     1  drop database if exists `sync_collation_increment2`;
     2  create database `sync_collation_increment2` character set utf8mb4 collate utf8mb4_general_ci;
     3  use `sync_collation_increment2`;
     4  create table t1 (id int, name varchar(20), primary key(`id`)) character set utf8mb4 collate utf8mb4_general_ci;
     5  insert into t1 (id, name) values (1, 'Aa'), (2, 'aA');
     6  create table t2 (id int, name varchar(20) character set utf8mb4 collate utf8mb4_general_ci, primary key(`id`)) character set latin1 collate latin1_bin;
     7  insert into t2 (id, name) values (1, 'Aa'), (2, 'aA');
     8  set collation_server = utf8mb4_general_ci;
     9  drop database if exists `sync_collation_server2`;
    10  create database `sync_collation_server2`;
    11  use `sync_collation_server2`;
    12  create table t1 (id int, name varchar(20), primary key(`id`));
    13  insert into t1 (id, name) values (1, 'Aa'), (2, 'aA');