2
create table t2 (c char(30)) charset=ucs2;
3
set @v=convert('abc' using ucs2);
5
insert into t2 values (@v);
6
show binlog events from <binlog_start>;
7
Log_name Pos Event_type Server_id End_log_pos Info
8
master-bin.000001 # User var # # @`v`=_ucs2 0x006100620063 COLLATE ucs2_general_ci
9
master-bin.000001 # Query # # use `test`; insert into t2 values (@v)
11
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
12
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
15
SET @`v`:=_ucs2 0x006100620063 COLLATE `ucs2_general_ci`/*!*/;
17
SET TIMESTAMP=10000/*!*/;
18
SET @@session.pseudo_thread_id=999999999/*!*/;
19
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
20
SET @@session.sql_mode=0/*!*/;
21
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
23
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
24
SET @@session.lc_time_names=0/*!*/;
25
SET @@session.collation_database=DEFAULT/*!*/;
26
insert into t2 values (@v)
30
ROLLBACK /* added by mysqlbinlog */;
31
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;