3
DROP DATABASE IF EXISTS mysqltest;
6
CREATE DATABASE mysqltest CHARSET UTF8;
8
CREATE TABLE t (cl varchar(100)) CHARSET UTF8;
12
LOAD DATA INFILE '../../std_data/loaddata_utf8.dat' INTO TABLE t
13
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
17
LOAD DATA LOCAL INFILE './std_data/loaddata_utf8.dat' INTO TABLE t
18
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
22
echo ----------content on master----------;
23
SELECT hex(cl) FROM t;
27
echo ----------content on slave----------;
29
SELECT hex(cl) FROM t;
32
DROP DATABASE mysqltest;