1source include/master-slave.inc;
2--disable_warnings
3drop database if exists mysqltest1;
4# 4.1 bases its conversion on the db's charset,
5# while 4.0 uses the part of "SET CHARACTER SET" after "_".
6# So for 4.1 we add a clause to CREATE DATABASE.
7create database mysqltest1 /*!40100 character set latin2 */;
8use mysqltest1;
9drop table if exists t1;
10--enable_warnings
11create table t1 (a varchar(255) character set latin2, b varchar(4));
12SET CHARACTER SET cp1250_latin2;
13INSERT INTO t1 VALUES ('�����','80');
14INSERT INTO t1 VALUES ('�����','90');
15INSERT INTO t1 VALUES ('����','A0');
16INSERT INTO t1 VALUES ('������','B0');
17INSERT INTO t1 VALUES ('����������������','C0');
18INSERT INTO t1 VALUES ('����������������','D0');
19INSERT INTO t1 VALUES ('����������������','E0');
20INSERT INTO t1 VALUES ('����������������','F0');
21select hex(a),b from t1 order by b;
22sync_slave_with_master;
23use mysqltest1;
24select hex(a),b from t1 order by b;
25connection master;
26drop database mysqltest1;
27sync_slave_with_master;
28
29# End of 4.1 tests
30--source include/rpl_end.inc
31