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

     1  drop database if exists `sync_collation`;
     2  create database `sync_collation` character set utf8;
     3  use `sync_collation`;
     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');