1stop slave;
2drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3reset master;
4reset slave;
5drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6start slave;
7show variables like 'collation_server';
8Variable_name	Value
9collation_server	ucs2_unicode_ci
10show variables like "%character_set_ser%";
11Variable_name	Value
12character_set_server	ucs2
13DROP TABLE IF EXISTS t1;
14CREATE TABLE `t1` ( `nid` int(11) NOT NULL default '0',
15`nom` char(4) default NULL,
16`prenom` char(4) default NULL,
17PRIMARY KEY  (`nid`))
18ENGINE=ndbcluster;
19INSERT INTO t1 VALUES(1,"XYZ1","ABC1");
20select * from t1 order by nid;
21nid	nom	prenom
221	XYZ1	ABC1
23select * from t1 order by nid;
24nid	nom	prenom
251	XYZ1	ABC1
26==== clean up ====
27DROP TABLE t1;
28