Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

View File Name : ctype_gb18030_binlog.test

--source include/force_myisam_default.inc

-- source include/force_binlog_format_statement.inc
-- source include/have_gb18030.inc

RESET MASTER;
SET NAMES gb18030;
--character_set gb18030

CREATE TABLE t1 (
  f1 BLOB
) DEFAULT CHARSET=gb18030;

delimiter |;
CREATE PROCEDURE p1(IN val BLOB)
BEGIN
     SET @tval = val;
     SET @sql_cmd = CONCAT_WS(' ', 'INSERT INTO t1(f1) VALUES(?)');
     PREPARE stmt FROM @sql_cmd;
     EXECUTE stmt USING @tval;
     DEALLOCATE PREPARE stmt;
END|
delimiter ;|

SET @`tcontent`:='����binlog���ƣ��������ֽڱ���:�9�1�9�2�9�3,���3�6���F';
CALL p1(@`tcontent`);

FLUSH LOGS;
DROP PROCEDURE p1;
RENAME TABLE t1 to t2;

let $MYSQLD_DATADIR= `select @@datadir`;
copy_file $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin-gb18030.saved;
# Reset GTIDs
RESET MASTER;
--exec $MYSQL_BINLOG --force-if-open --short-form $MYSQLD_DATADIR/master-bin-gb18030.saved | $MYSQL
SELECT hex(f1), f1 FROM t2;
SELECT hex(f1), f1 FROM t1;

DROP PROCEDURE p1;
DROP TABLE t1;
DROP TABLE t2;
--remove_file $MYSQLD_DATADIR/master-bin-gb18030.saved

--source include/restore_default_binlog_format.inc