ctype_cp932_binlog.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- drop table if exists t1;
- set names cp932;
- set character_set_database = cp932;
- RESET MASTER;
- CREATE TABLE t1(f1 blob);
- PREPARE stmt1 FROM 'INSERT INTO t1 VALUES(?)';
- SET @var1= x'8300';
- EXECUTE stmt1 USING @var1;
- SHOW BINLOG EVENTS FROM 79;
- Log_name Pos Event_type Server_id Orig_log_pos Info
- master-bin.000001 # Query 1 # use `test`; SET ONE_SHOT CHARACTER_SET_CLIENT=95,COLLATION_CONNECTION=95,COLLATION_DATABASE=95,COLLATION_SERVER=8
- master-bin.000001 # Query 1 # use `test`; CREATE TABLE t1(f1 blob)
- master-bin.000001 # Query 1 # use `test`; SET ONE_SHOT CHARACTER_SET_CLIENT=95,COLLATION_CONNECTION=95,COLLATION_DATABASE=95,COLLATION_SERVER=8
- master-bin.000001 # User var 1 # @`var1`=_binary 0x8300 COLLATE binary
- master-bin.000001 # Query 1 # use `test`; INSERT INTO t1 VALUES(@'var1')
- SELECT HEX(f1) FROM t1;
- HEX(f1)
- 8300
- DROP table t1;