slave stop;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
slave start;
drop database if exists mysqltest1;
create database mysqltest1 /*!40100 character set latin2 */;
use mysqltest1;
drop table if exists t1;
create table t1 (a varchar(255) character set latin2, b varchar(4));
SET CHARACTER SET cp1250_latin2;
INSERT INTO t1 VALUES ('�����','80');
INSERT INTO t1 VALUES ('�����','90');
INSERT INTO t1 VALUES ('����','A0');
INSERT INTO t1 VALUES ('������','B0');
INSERT INTO t1 VALUES ('����������������','C0');
INSERT INTO t1 VALUES ('����������������','D0');
INSERT INTO t1 VALUES ('����������������','E0');
INSERT INTO t1 VALUES ('�������������','F0');
select "--- on master ---";
--- on master ---
--- on master ---
select hex(a),b from t1 order by b;
hex(a)	b
A9A6ABAEAC	80
B9B6BBBEBC	90
A3A1AAAF	A0
B3B1BAA5B5BF	B0
C0C1C2C3C4C5C6C7C8C9CACBCCCDCECF	C0
D0D1D2D3D4D5D6D7D8D9DADBDCDDDEDF	D0
E0E1E2E3E4E5E6E7E8E9EAEBECEDEEEF	E0
F0F1F2F3F4F5F6F7F8F9FAFBFCFDFEFF	F0
show binlog events from 1979;
Log_name	Pos	Event_type	Server_id	Orig_log_pos	Info
master-bin.001	1979	Query	1	1979	use `mysqltest1`; SET CHARACTER SET DEFAULT
use mysqltest1;
select "--- on slave ---";
--- on slave ---
--- on slave ---
select hex(a),b from t1 order by b;
hex(a)	b
A9A6ABAEAC	80
B9B6BBBEBC	90
A3A1AAAF	A0
B3B1BAA5B5BF	B0
C0C1C2C3C4C5C6C7C8C9CACBCCCDCECF	C0
D0D1D2D3D4D5D6D7D8D9DADBDCDDDEDF	D0
E0E1E2E3E4E5E6E7E8E9EAEBECEDEEEF	E0
F0F1F2F3F4F5F6F7F8F9FAFBFCFDFEFF	F0
drop database mysqltest1;