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