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(0x8300)
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 785 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 785 Query 1 1049 use `test`; INSERT INTO t4 VALUES ( NAME_CONST('ins1',_latin1 0x466F6F2773206120426172 COLLATE 'latin1_swedish_ci'), NAME_CONST('ins2',_cp932 0xED40ED41ED42 COLLATE 'cp932_japanese_ci'), NAME_CONST('ind',47.93))
44
master-bin.000001 1049 Query 1 1138 use `test`; DROP PROCEDURE bug18293
45
master-bin.000001 1138 Query 1 1217 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
49
Bug#44352 UPPER/LOWER function doesn't work correctly on cp932 and sjis environment.
50
CREATE TABLE t1 (a varchar(16)) character set cp932;
51
INSERT INTO t1 VALUES (0x8372835E),(0x8352835E);
52
SELECT hex(a), hex(lower(a)), hex(upper(a)) FROM t1 ORDER BY binary(a);
53
hex(a) hex(lower(a)) hex(upper(a))
54
8352835E 8352835E 8352835E
55
8372835E 8372835E 8372835E