# # Check LOAD DATA + character sets + replication # source include/master-slave.inc; # # Bug#15126 character_set_database is not replicated # (LOAD DATA INFILE need it) # connection master; create table t1 (a varchar(10) character set utf8); load data infile '../../std_data/loaddata6.dat' into table t1; set @@character_set_database=koi8r; load data infile '../../std_data/loaddata6.dat' into table t1; set @@character_set_database=DEFAULT; load data infile '../../std_data/loaddata6.dat' into table t1; load data infile '../../std_data/loaddata6.dat' into table t1; load data infile '../../std_data/loaddata6.dat' into table t1; set @@character_set_database=koi8r; load data infile '../../std_data/loaddata6.dat' into table t1; set @@character_set_database=DEFAULT; load data infile '../../std_data/loaddata6.dat' into table t1 character set koi8r; select hex(a) from t1; save_master_pos; connection slave; sync_with_master; select hex(a) from t1; connection master; drop table t1; sync_slave_with_master;