1
show variables like 'collation_server';
3
collation_server ucs2_unicode_ci
4
show variables like "%character_set_ser%";
6
character_set_server ucs2
7
DROP TABLE IF EXISTS t1;
8
create table t1 (a int);
11
create table t1 (a char(1) character set latin1);
12
insert into t1 values ('a'),('b'),('c');
13
select hex(group_concat(a)) from t1;
17
CREATE TABLE t1(col1 VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_bin NOT NULL,
18
col2 VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_bin NOT NULL,
19
UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY;
20
INSERT INTO t1 VALUES('A', 'A'), ('B', 'B'), ('C', 'C');
21
INSERT INTO t1 VALUES('A ', 'A ');
22
ERROR 23000: Duplicate entry '' for key 'key1'
25
c1 CHAR(255) CHARACTER SET UCS2 COLLATE UCS2_BIN NOT NULL,
28
INSERT INTO t1 VALUES ('marshall\'s');
29
INSERT INTO t1 VALUES ('marsh');
30
CHECK TABLE t1 EXTENDED;
31
Table Op Msg_type Msg_text
32
test.t1 check status OK