1SET TIMESTAMP=10000; 2create table t2 (c char(30)) charset=ucs2; 3set @v=convert('abc' using ucs2); 4reset master; 5insert into t2 values (@v); 6include/show_binlog_events.inc 7Log_name Pos Event_type Server_id End_log_pos Info 8master-bin.000001 # Query # # BEGIN 9master-bin.000001 # User var # # @`v`=_ucs2 0x006100620063 COLLATE ucs2_general_ci 10master-bin.000001 # Query # # use `test`; insert into t2 values (@v) 11master-bin.000001 # Query # # COMMIT 12flush logs; 13/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; 14/*!40019 SET @@session.max_insert_delayed_threads=0*/; 15/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; 16DELIMITER /*!*/; 17ROLLBACK/*!*/; 18# [empty] 19SET @@SESSION.GTID_NEXT= 'GTID'/*!*/; 20SET TIMESTAMP=10000/*!*/; 21SET @@session.pseudo_thread_id=999999999/*!*/; 22SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; 23SET @@session.sql_mode=1073741824/*!*/; 24SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; 25/*!\C latin1 *//*!*/; 26SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; 27SET @@session.lc_time_names=0/*!*/; 28SET @@session.collation_database=DEFAULT/*!*/; 29BEGIN 30/*!*/; 31SET @`v`:=_ucs2 0x006100620063 COLLATE `ucs2_general_ci`/*!*/; 32use `test`/*!*/; 33SET TIMESTAMP=10000/*!*/; 34insert into t2 values (@v) 35/*!*/; 36SET TIMESTAMP=10000/*!*/; 37COMMIT 38/*!*/; 39SET @@SESSION.GTID_NEXT= 'GTID' /* added by mysqlbinlog */ /*!*/; 40DELIMITER ; 41# End of log file 42ROLLBACK /* added by mysqlbinlog */; 43/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; 44/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 45drop table t2; 46