Edit File: ctype_ucs2_def.result
show variables like 'collation_server'; Variable_name Value collation_server ucs2_unicode_ci show variables like "%character_set_ser%"; Variable_name Value character_set_server ucs2 DROP TABLE IF EXISTS t1; create table t1 (a int); drop table t1; End of 4.1 tests create table t1 (a char(1) character set latin1); insert into t1 values ('a'),('b'),('c'); select hex(group_concat(a)) from t1; hex(group_concat(a)) 612C622C63 drop table t1; CREATE TABLE t1(col1 VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_bin NOT NULL, col2 VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_bin NOT NULL, UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY; INSERT INTO t1 VALUES('A', 'A'), ('B', 'B'), ('C', 'C'); INSERT INTO t1 VALUES('A ', 'A '); ERROR 23000: Duplicate entry 'A -A ' for key 'key1' DROP TABLE t1; CREATE TABLE t1 ( c1 CHAR(255) CHARACTER SET UCS2 COLLATE UCS2_BIN NOT NULL, KEY(c1) ) ENGINE=MyISAM; INSERT INTO t1 VALUES ('marshall\'s'); INSERT INTO t1 VALUES ('marsh'); CHECK TABLE t1 EXTENDED; Table Op Msg_type Msg_text test.t1 check status OK DROP TABLE t1; End of 5.0 tests
Back to File Manager