rpl_set_charset.result 1.53 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
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 table t1;
unknown's avatar
unknown committed
52
drop database mysqltest1;