--source include/master-slave.inc set names gbk; #set binlog_format='row'; CREATE TABLE `mytest` ( `a` blob ) ENGINE=MyISAM DEFAULT CHARSET=gbk; delimiter |; CREATE PROCEDURE `my_proc`(IN val BLOB) BEGIN SET @tval = val; SET @sql_cmd = CONCAT_WS(' ', 'insert into mytest(a) values(?)'); PREPARE stmt FROM @sql_cmd; EXECUTE stmt USING @tval; DEALLOCATE PREPARE stmt; END | delimiter ;| SET @`tcontent`:=_binary 0x50434B000900000000000000E9000000 COLLATE `binary`/*!*/; call my_proc(@`tcontent`); select hex(a) from mytest; sleep 1; connection slave; select hex(a) from mytest;