1
--source include/have_sjis.inc
2
--source include/have_innodb.inc
5
drop table if exists `�s�P`;
6
drop table if exists `�s�Q`;
7
drop table if exists `�s�R`;
8
drop table if exists `�s�S`;
9
drop table if exists `�s�T`;
10
drop table if exists `�s�U`;
11
drop table if exists `�s�V`;
12
drop table if exists `�s�W`;
13
drop table if exists `�s�X`;
14
drop table if exists t1;
18
# Test ENUM values with Japanese characters in sjis encoding
22
SET character_set_database = sjis;
24
CREATE TABLE `�s�P` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
25
CREATE TABLE `�s�Q` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
26
CREATE TABLE `�s�R` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
27
CREATE TABLE `�s�S` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `�s�T` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
29
CREATE TABLE `�s�U` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
30
CREATE TABLE `�s�V` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31
CREATE TABLE `�s�W` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
32
CREATE TABLE `�s�X` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
34
INSERT INTO `�s�P` VALUES ('�'),('�'),('�');
35
INSERT INTO `�s�Q` VALUES ('��'),('��'),('��');
36
INSERT INTO `�s�R` VALUES ('�\'),('�\'),('�\');
37
INSERT INTO `�s�S` VALUES ('�'),('�'),('�');
38
INSERT INTO `�s�T` VALUES ('��'),('��'),('��');
39
INSERT INTO `�s�U` VALUES ('�\'),('�\'),('�\');
40
INSERT INTO `�s�V` VALUES ('�'),('�'),('�');
41
INSERT INTO `�s�W` VALUES ('��'),('��'),('��');
42
INSERT INTO `�s�X` VALUES ('�\'),('�\'),('�\');
54
SHOW CREATE TABLE `�s�P`;
55
SHOW CREATE TABLE `�s�Q`;
56
SHOW CREATE TABLE `�s�R`;
57
SHOW CREATE TABLE `�s�S`;
58
SHOW CREATE TABLE `�s�T`;
59
SHOW CREATE TABLE `�s�U`;
60
SHOW CREATE TABLE `�s�V`;
61
SHOW CREATE TABLE `�s�W`;
62
SHOW CREATE TABLE `�s�X`;
75
# Test problem with enum values after the colum with NOT NULL restriction
78
ALTER TABLE `�s�P` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
79
ALTER TABLE `�s�Q` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
80
ALTER TABLE `�s�R` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
81
ALTER TABLE `�s�S` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
82
ALTER TABLE `�s�T` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
83
ALTER TABLE `�s�U` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
84
ALTER TABLE `�s�V` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
85
ALTER TABLE `�s�W` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
86
ALTER TABLE `�s�X` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
88
SHOW CREATE TABLE `�s�P`;
89
SHOW CREATE TABLE `�s�Q`;
90
SHOW CREATE TABLE `�s�R`;
91
SHOW CREATE TABLE `�s�S`;
92
SHOW CREATE TABLE `�s�T`;
93
SHOW CREATE TABLE `�s�U`;
94
SHOW CREATE TABLE `�s�V`;
95
SHOW CREATE TABLE `�s�W`;
96
SHOW CREATE TABLE `�s�X`;
99
# Test to distinguish 0x9353 and 0x9373
100
# Bug#6206 ENUMs are not case sensitive even if declared BINARY
103
CREATE TABLE t1(c1 enum('�S','�s')) default character set = sjis;
104
INSERT INTO t1 VALUES('�S'),('�s');
105
SELECT * FROM t1 WHERE c1 LIKE '�S';