1
-- source include/have_binlog_format_mixed_or_statement.inc
2
-- source include/have_cp932.inc
3
-- source include/have_log_bin.inc
5
# Bug#16217 (mysql client did not know how not switch its internal charset)
7
create table t3 (f text character set utf8);
8
create table t4 (f text character set cp932);
9
--exec $MYSQL --default-character-set=utf8 test -e "insert into t3 values(_utf8'ソ')"
10
--exec $MYSQL --default-character-set=cp932 test -e "insert into t4 values(_cp932'�\');"
12
rename table t3 to t03, t4 to t04;
13
--exec $DRIZZLE_BINLOG --short-form $MYSQLTEST_VARDIR/log/master-bin.000002 | $MYSQL --default-character-set=utf8
14
# original and recovered data must be equal
15
select HEX(f) from t03;
16
select HEX(f) from t3;
17
select HEX(f) from t04;
18
select HEX(f) from t4;
20
drop table t3, t4, t03, t04;
21
--echo End of 5.0 tests