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

     1  drop database if exists `sync_collation2`;
     2  create database `sync_collation2` character set utf8mb4 collate utf8mb4_general_ci;
     3  use `sync_collation2`;
     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  
     9  drop database if exists `test_panic`;
    10  create database `test_panic`;
    11  use `test_panic`;
    12  create table t1 (
    13      id int PRIMARY KEY,
    14      name varchar(20) COLLATE utf8mb4_0900_as_cs
    15  );