1
-- source include/have_euckr.inc
4
# Tests with the euckr character set
7
drop table if exists t1;
10
SET @test_character_set= 'euckr';
11
SET @test_collation= 'euckr_korean_ci';
12
-- source include/ctype_common.inc
15
SET collation_connection='euckr_korean_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='euckr_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#15377 Valid multibyte sequences are truncated on INSERT
30
CREATE TABLE t1 (a text) character set euckr;
31
INSERT INTO t1 VALUES (0xA2E6),(0xFEF7);
32
SELECT hex(a) FROM t1 ORDER BY a;
39
--source include/weight_string.inc
40
--source include/weight_string_l1.inc
41
--source include/weight_string_A1A1.inc
43
set collation_connection=euckr_bin;
44
--source include/weight_string.inc
45
--source include/weight_string_l1.inc
46
--source include/weight_string_A1A1.inc
49
#Bug #30315 Character sets: insertion of euckr code value 0xa141 fails
51
create table t1 (s1 varchar(5) character set euckr);
52
# Insert some valid characters
53
insert into t1 values (0xA141);
54
insert into t1 values (0xA15A);
55
insert into t1 values (0xA161);
56
insert into t1 values (0xA17A);
57
insert into t1 values (0xA181);
58
insert into t1 values (0xA1FE);
59
# Insert some invalid characters
60
insert into t1 values (0xA140);
61
insert into t1 values (0xA15B);
62
insert into t1 values (0xA160);
63
insert into t1 values (0xA17B);
64
insert into t1 values (0xA180);
65
insert into t1 values (0xA1FF);
66
select hex(s1), hex(convert(s1 using utf8)) from t1 order by binary s1;
69
--echo End of 5.0 tests