1
drop table if exists t1;
3
set character_set_database = cp932;
5
CREATE TABLE t1(f1 blob);
6
PREPARE stmt1 FROM 'INSERT INTO t1 VALUES(?)';
8
EXECUTE stmt1 USING @var1;
9
show binlog events from <binlog_start>;
10
Log_name Pos Event_type Server_id End_log_pos Info
11
master-bin.000001 # Query # # use `test`; CREATE TABLE t1(f1 blob)
12
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES('�\0')
13
SELECT HEX(f1) FROM t1;
17
CREATE TABLE t4 (s1 CHAR(50) CHARACTER SET latin1,
18
s2 CHAR(50) CHARACTER SET cp932,
20
CREATE PROCEDURE bug18293 (IN ins1 CHAR(50),
21
IN ins2 CHAR(50) CHARACTER SET cp932,
24
INSERT INTO t4 VALUES (ins1, ins2, ind);
26
CALL bug18293("Foo's a Bar", _cp932 0xED40ED41ED42, 47.93)|
27
SELECT HEX(s1),HEX(s2),d FROM t4|
29
466F6F2773206120426172 ED40ED41ED42 47.93
30
DROP PROCEDURE bug18293|
32
SHOW BINLOG EVENTS FROM 370|
33
Log_name Pos Event_type Server_id End_log_pos Info
34
master-bin.000001 370 Query 1 536 use `test`; CREATE TABLE t4 (s1 CHAR(50) CHARACTER SET latin1,
35
s2 CHAR(50) CHARACTER SET cp932,
37
master-bin.000001 536 Query 1 784 use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE bug18293 (IN ins1 CHAR(50),
38
IN ins2 CHAR(50) CHARACTER SET cp932,
41
INSERT INTO t4 VALUES (ins1, ins2, ind);
43
master-bin.000001 784 Query 1 992 use `test`; INSERT INTO t4 VALUES ( NAME_CONST('ins1',_latin1 0x466F6F2773206120426172), NAME_CONST('ins2',_cp932 0xED40ED41ED42), NAME_CONST('ind',47.93))
44
master-bin.000001 992 Query 1 1081 use `test`; DROP PROCEDURE bug18293
45
master-bin.000001 1081 Query 1 1160 use `test`; DROP TABLE t4
47
SHOW BINLOG EVENTS FROM 365;
48
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O error
50
select @@collation_connection;
51
@@collation_connection
53
select hex(weight_string('a'));
54
hex(weight_string('a'))
56
select hex(weight_string('A'));
57
hex(weight_string('A'))
59
select hex(weight_string('abc'));
60
hex(weight_string('abc'))
62
select hex(weight_string('abc' as char(2)));
63
hex(weight_string('abc' as char(2)))
65
select hex(weight_string('abc' as char(3)));
66
hex(weight_string('abc' as char(3)))
68
select hex(weight_string('abc' as char(5)));
69
hex(weight_string('abc' as char(5)))
71
select @@collation_connection;
72
@@collation_connection
74
select hex(weight_string('a' LEVEL 1));
75
hex(weight_string('a' LEVEL 1))
77
select hex(weight_string('A' LEVEL 1));
78
hex(weight_string('A' LEVEL 1))
80
select hex(weight_string('abc' LEVEL 1));
81
hex(weight_string('abc' LEVEL 1))
83
select hex(weight_string('abc' as char(2) LEVEL 1));
84
hex(weight_string('abc' as char(2) LEVEL 1))
86
select hex(weight_string('abc' as char(3) LEVEL 1));
87
hex(weight_string('abc' as char(3) LEVEL 1))
89
select hex(weight_string('abc' as char(5) LEVEL 1));
90
hex(weight_string('abc' as char(5) LEVEL 1))
92
select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE));
93
hex(weight_string('abc' as char(5) LEVEL 1 REVERSE))
95
select hex(weight_string('abc' as char(5) LEVEL 1 DESC));
96
hex(weight_string('abc' as char(5) LEVEL 1 DESC))
98
select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE));
99
hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE))
101
select collation(cast(0x8140 as char));
102
collation(cast(0x8140 as char))
104
select hex(weight_string(cast(0x6141 as char)));
105
hex(weight_string(cast(0x6141 as char)))
107
select hex(weight_string(cast(0x8140 as char)));
108
hex(weight_string(cast(0x8140 as char)))
110
select hex(weight_string(cast(0x8140 as char) as char(1)));
111
hex(weight_string(cast(0x8140 as char) as char(1)))
113
select hex(weight_string(cast(0x81408140 as char) as char(1)));
114
hex(weight_string(cast(0x81408140 as char) as char(1)))
116
select hex(weight_string(cast(0x8140 as char) as char(3)));
117
hex(weight_string(cast(0x8140 as char) as char(3)))
119
select hex(weight_string(cast(0x81408140 as char) as char(3)));
120
hex(weight_string(cast(0x81408140 as char) as char(3)))
122
select hex(weight_string(cast(0x408140 as char) as char(3)));
123
hex(weight_string(cast(0x408140 as char) as char(3)))
125
select hex(weight_string(cast(0x4081408140 as char) as char(3)));
126
hex(weight_string(cast(0x4081408140 as char) as char(3)))
128
select hex(weight_string(cast(0x40814081408140 as char) as char(3)));
129
hex(weight_string(cast(0x40814081408140 as char) as char(3)))
131
select hex(weight_string(cast(0x4040814081408140 as char) as char(3)));
132
hex(weight_string(cast(0x4040814081408140 as char) as char(3)))
134
set collation_connection=cp932_bin;
135
select @@collation_connection;
136
@@collation_connection
138
select hex(weight_string('a'));
139
hex(weight_string('a'))
141
select hex(weight_string('A'));
142
hex(weight_string('A'))
144
select hex(weight_string('abc'));
145
hex(weight_string('abc'))
147
select hex(weight_string('abc' as char(2)));
148
hex(weight_string('abc' as char(2)))
150
select hex(weight_string('abc' as char(3)));
151
hex(weight_string('abc' as char(3)))
153
select hex(weight_string('abc' as char(5)));
154
hex(weight_string('abc' as char(5)))
156
select @@collation_connection;
157
@@collation_connection
159
select hex(weight_string('a' LEVEL 1));
160
hex(weight_string('a' LEVEL 1))
162
select hex(weight_string('A' LEVEL 1));
163
hex(weight_string('A' LEVEL 1))
165
select hex(weight_string('abc' LEVEL 1));
166
hex(weight_string('abc' LEVEL 1))
168
select hex(weight_string('abc' as char(2) LEVEL 1));
169
hex(weight_string('abc' as char(2) LEVEL 1))
171
select hex(weight_string('abc' as char(3) LEVEL 1));
172
hex(weight_string('abc' as char(3) LEVEL 1))
174
select hex(weight_string('abc' as char(5) LEVEL 1));
175
hex(weight_string('abc' as char(5) LEVEL 1))
177
select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE));
178
hex(weight_string('abc' as char(5) LEVEL 1 REVERSE))
180
select hex(weight_string('abc' as char(5) LEVEL 1 DESC));
181
hex(weight_string('abc' as char(5) LEVEL 1 DESC))
183
select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE));
184
hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE))
186
select collation(cast(0x8140 as char));
187
collation(cast(0x8140 as char))
189
select hex(weight_string(cast(0x6141 as char)));
190
hex(weight_string(cast(0x6141 as char)))
192
select hex(weight_string(cast(0x8140 as char)));
193
hex(weight_string(cast(0x8140 as char)))
195
select hex(weight_string(cast(0x8140 as char) as char(1)));
196
hex(weight_string(cast(0x8140 as char) as char(1)))
198
select hex(weight_string(cast(0x81408140 as char) as char(1)));
199
hex(weight_string(cast(0x81408140 as char) as char(1)))
201
select hex(weight_string(cast(0x8140 as char) as char(3)));
202
hex(weight_string(cast(0x8140 as char) as char(3)))
204
select hex(weight_string(cast(0x81408140 as char) as char(3)));
205
hex(weight_string(cast(0x81408140 as char) as char(3)))
207
select hex(weight_string(cast(0x408140 as char) as char(3)));
208
hex(weight_string(cast(0x408140 as char) as char(3)))
210
select hex(weight_string(cast(0x4081408140 as char) as char(3)));
211
hex(weight_string(cast(0x4081408140 as char) as char(3)))
213
select hex(weight_string(cast(0x40814081408140 as char) as char(3)));
214
hex(weight_string(cast(0x40814081408140 as char) as char(3)))
216
select hex(weight_string(cast(0x4040814081408140 as char) as char(3)));
217
hex(weight_string(cast(0x4040814081408140 as char) as char(3)))