1
-- source include/have_gbk.inc
4
# Tests with the gbk character set
7
drop table if exists t1;
10
SET @test_character_set= 'gbk';
11
SET @test_collation= 'gbk_chinese_ci';
12
-- source include/ctype_common.inc
15
SET collation_connection='gbk_chinese_ci';
16
-- source include/ctype_filesort.inc
17
-- source include/ctype_innodb_like.inc
18
-- source include/ctype_like_escape.inc
19
-- source include/ctype_like_range_f1f2.inc
20
SET collation_connection='gbk_bin';
21
-- source include/ctype_filesort.inc
22
-- source include/ctype_innodb_like.inc
23
-- source include/ctype_like_escape.inc
24
-- source include/ctype_like_range_f1f2.inc
27
# Bug#11987 mysql will truncate the text when
28
# the text contain GBK char:"0xA3A0" and "0xA1"
31
CREATE TABLE t1 (a text) character set gbk;
32
INSERT INTO t1 VALUES (0xA3A0),(0xA1A1);
33
SELECT hex(a) FROM t1 ORDER BY a;
37
# Bugs#15375: Unassigned multibyte codes are broken
38
# into parts when converting to Unicode.
39
# This query should return 0x003F0041. I.e. it should
40
# scan unassigned double-byte character 0xA140, convert
41
# it as QUESTION MARK 0x003F and then scan the next
42
# character, which is a single byte character 0x41.
44
select hex(convert(_gbk 0xA14041 using ucs2));
49
# Bug#21620 ALTER TABLE affects other columns
51
create table t1 (c1 text not null, c2 text not null) character set gbk;
52
alter table t1 change c1 c1 mediumtext character set gbk not null;
56
--echo End of 5.0 tests
60
--source include/weight_string.inc
61
--source include/weight_string_l1.inc
62
--source include/weight_string_A1A1.inc
63
--source include/weight_string_8140.inc
64
--source include/weight_string_8EA1.inc
66
set collation_connection=gbk_bin;
67
--source include/weight_string.inc
68
--source include/weight_string_l1.inc
69
--source include/weight_string_A1A1.inc
70
--source include/weight_string_8140.inc
71
--source include/weight_string_8EA1.inc