--source include/master-slave.inc alter database test character set latin1; show variables like 'char%'; create table test1(id smallint not null primary key, testtext varchar(100) not null) engine InnoDB; show create table test1; --sync_slave_with_master show variables like 'char%'; drop table test1; alter database test character set utf8mb4; create table test1(id smallint not null primary key, testtext varchar(100) not null) engine InnoDB; show create table test1; --connection master insert into test1 (id, testtext) values(1, "zü"); select testtext, hex(testtext) from test1 where id=1; --sync_slave_with_master select testtext, hex(testtext) from test1 where id=1; --connection master drop table test1; alter database test character set utf8mb4; --sync_slave_with_master --source include/rpl_end.inc