summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/rpl/r/rpl_set_charset.result
blob: 92749ed5d990eab45e0f06dc0a7daed2095cc6ca (plain)
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
include/master-slave.inc
[connection master]
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 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
connection slave;
use mysqltest1;
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
connection master;
drop database mysqltest1;
connection slave;
include/rpl_end.inc