Edit File: ctype_gbk_binlog.result
RESET MASTER; SET NAMES gbk; CREATE TABLE t1 ( f1 BLOB ) ENGINE=MyISAM DEFAULT CHARSET=gbk; CREATE PROCEDURE p1(IN val BLOB) BEGIN SET @tval = val; SET @sql_cmd = CONCAT_WS(' ', 'insert into t1(f1) values(?)'); PREPARE stmt FROM @sql_cmd; EXECUTE stmt USING @tval; DEALLOCATE PREPARE stmt; END| SET @`tcontent`:=_binary 0x50434B000900000000000000E9000000 COLLATE `binary`/*!*/; CALL p1(@`tcontent`); FLUSH LOGS; DROP PROCEDURE p1; RENAME TABLE t1 to t2; SELECT hex(f1) FROM t2; hex(f1) 50434B000900000000000000E9000000 SELECT hex(f1) FROM t1; hex(f1) 50434B000900000000000000E9000000 DROP PROCEDURE p1; DROP TABLE t1; DROP TABLE t2;
Back to File Manager