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

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