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 # Query # # use `test`; BEGIN
9
master-bin.000001 # Table_map # # table_id: # (test.t2)
10
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
11
master-bin.000001 # Query # # use `test`; COMMIT
13
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
14
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
18
SET TIMESTAMP=10000/*!*/;
19
SET @@session.pseudo_thread_id=999999999/*!*/;
20
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
21
SET @@session.sql_mode=0/*!*/;
22
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
24
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
25
SET @@session.lc_time_names=0/*!*/;
26
SET @@session.collation_database=DEFAULT/*!*/;
29
SET TIMESTAMP=10000/*!*/;
34
ROLLBACK /* added by mysqlbinlog */;
35
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;