1include/master-slave.inc 2[connection master] 3drop database if exists mysqltest1; 4create database mysqltest1 /*!40100 character set latin2 */; 5use mysqltest1; 6drop table if exists t1; 7create table t1 (a varchar(255) character set latin2, b varchar(4)); 8SET CHARACTER SET cp1250_latin2; 9INSERT INTO t1 VALUES ('�����','80'); 10INSERT INTO t1 VALUES ('�����','90'); 11INSERT INTO t1 VALUES ('����','A0'); 12INSERT INTO t1 VALUES ('������','B0'); 13INSERT INTO t1 VALUES ('����������������','C0'); 14INSERT INTO t1 VALUES ('����������������','D0'); 15INSERT INTO t1 VALUES ('����������������','E0'); 16INSERT INTO t1 VALUES ('����������������','F0'); 17select hex(a),b from t1 order by b; 18hex(a) b 19A9A6ABAEAC 80 20B9B6BBBEBC 90 21A3A1AAAF A0 22B3B1BAA5B5BF B0 23C0C1C2C3C4C5C6C7C8C9CACBCCCDCECF C0 24D0D1D2D3D4D5D6D7D8D9DADBDCDDDEDF D0 25E0E1E2E3E4E5E6E7E8E9EAEBECEDEEEF E0 26F0F1F2F3F4F5F6F7F8F9FAFBFCFDFEFF F0 27connection slave; 28use mysqltest1; 29select hex(a),b from t1 order by b; 30hex(a) b 31A9A6ABAEAC 80 32B9B6BBBEBC 90 33A3A1AAAF A0 34B3B1BAA5B5BF B0 35C0C1C2C3C4C5C6C7C8C9CACBCCCDCECF C0 36D0D1D2D3D4D5D6D7D8D9DADBDCDDDEDF D0 37E0E1E2E3E4E5E6E7E8E9EAEBECEDEEEF E0 38F0F1F2F3F4F5F6F7F8F9FAFBFCFDFEFF F0 39connection master; 40drop database mysqltest1; 41connection slave; 42include/rpl_end.inc 43