3
drop table if exists `�s�P`;
4
drop table if exists `�s�Q`;
5
drop table if exists `�s�R`;
6
drop table if exists `�s�S`;
7
drop table if exists `�s�T`;
8
drop table if exists `�s�U`;
9
drop table if exists `�s�V`;
10
drop table if exists `�s�W`;
11
drop table if exists `�s�X`;
12
drop table if exists `�s�P�O`;
16
# Test INSTR() function with Japanese characters in sjis encoding
20
SET character_set_database = sjis;
22
CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
23
CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
24
CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
25
CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
26
CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
27
CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
29
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
30
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
31
CREATE TABLE `�s�P�O` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
32
CREATE TABLE `�s�P�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
33
CREATE TABLE `�s�P�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
35
INSERT INTO `�s�P` VALUES ('�����');
36
INSERT INTO `�s�Q` VALUES ('����������');
37
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
38
INSERT INTO `�s�S` VALUES ('�����');
39
INSERT INTO `�s�T` VALUES ('����������');
40
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\');
41
INSERT INTO `�s�V` VALUES ('�����');
42
INSERT INTO `�s�W` VALUES ('����������');
43
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
44
INSERT INTO `�s�P�O` VALUES ('�����');
45
INSERT INTO `�s�P�P` VALUES ('����������');
46
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
49
SELECT INSTR(`�b�P`,'�') from `�s�P`;
50
SELECT INSTR(`�b�P`,'�') from `�s�P`;
51
SELECT INSTR(`�b�P`,'�') from `�s�P`;
52
SELECT INSTR(`�b�P`,'�') from `�s�P`;
53
SELECT INSTR(`�b�P`,'�') from `�s�P`;
54
SELECT INSTR(`�b�P`,'�') from `�s�P`;
55
SELECT INSTR(`�b�P`,'��') from `�s�Q`;
56
SELECT INSTR(`�b�P`,'��') from `�s�Q`;
57
SELECT INSTR(`�b�P`,'��') from `�s�Q`;
58
SELECT INSTR(`�b�P`,'��') from `�s�Q`;
59
SELECT INSTR(`�b�P`,'��') from `�s�Q`;
60
SELECT INSTR(`�b�P`,'��') from `�s�Q`;
61
SELECT INSTR(`�b�P`,'�\') from `�s�R`;
62
SELECT INSTR(`�b�P`,'�\') from `�s�R`;
63
SELECT INSTR(`�b�P`,'�\') from `�s�R`;
64
SELECT INSTR(`�b�P`,'�\') from `�s�R`;
65
SELECT INSTR(`�b�P`,'�\') from `�s�R`;
66
SELECT INSTR(`�b�P`,'�\') from `�s�R`;
69
SELECT INSTR(`�b�P`,'�') from `�s�S`;
70
SELECT INSTR(`�b�P`,'�') from `�s�S`;
71
SELECT INSTR(`�b�P`,'�') from `�s�S`;
72
SELECT INSTR(`�b�P`,'�') from `�s�S`;
73
SELECT INSTR(`�b�P`,'�') from `�s�S`;
74
SELECT INSTR(`�b�P`,'�') from `�s�S`;
75
SELECT INSTR(`�b�P`,'��') from `�s�T`;
76
SELECT INSTR(`�b�P`,'��') from `�s�T`;
77
SELECT INSTR(`�b�P`,'��') from `�s�T`;
78
SELECT INSTR(`�b�P`,'��') from `�s�T`;
79
SELECT INSTR(`�b�P`,'��') from `�s�T`;
80
SELECT INSTR(`�b�P`,'��') from `�s�T`;
81
SELECT INSTR(`�b�P`,'�\') from `�s�U`;
82
SELECT INSTR(`�b�P`,'�\') from `�s�U`;
83
SELECT INSTR(`�b�P`,'�\') from `�s�U`;
84
SELECT INSTR(`�b�P`,'�\') from `�s�U`;
85
SELECT INSTR(`�b�P`,'�\') from `�s�U`;
86
SELECT INSTR(`�b�P`,'�\') from `�s�U`;
89
SELECT INSTR(`�b�P`,'�') from `�s�V`;
90
SELECT INSTR(`�b�P`,'�') from `�s�V`;
91
SELECT INSTR(`�b�P`,'�') from `�s�V`;
92
SELECT INSTR(`�b�P`,'�') from `�s�V`;
93
SELECT INSTR(`�b�P`,'�') from `�s�V`;
94
SELECT INSTR(`�b�P`,'�') from `�s�V`;
95
SELECT INSTR(`�b�P`,'��') from `�s�W`;
96
SELECT INSTR(`�b�P`,'��') from `�s�W`;
97
SELECT INSTR(`�b�P`,'��') from `�s�W`;
98
SELECT INSTR(`�b�P`,'��') from `�s�W`;
99
SELECT INSTR(`�b�P`,'��') from `�s�W`;
100
SELECT INSTR(`�b�P`,'��') from `�s�W`;
101
SELECT INSTR(`�b�P`,'�\') from `�s�X`;
102
SELECT INSTR(`�b�P`,'�\') from `�s�X`;
103
SELECT INSTR(`�b�P`,'�\') from `�s�X`;
104
SELECT INSTR(`�b�P`,'�\') from `�s�X`;
105
SELECT INSTR(`�b�P`,'�\') from `�s�X`;
106
SELECT INSTR(`�b�P`,'�\') from `�s�X`;
109
SELECT INSTR(`�b�P`,'�') from `�s�P�O`;
110
SELECT INSTR(`�b�P`,'�') from `�s�P�O`;
111
SELECT INSTR(`�b�P`,'�') from `�s�P�O`;
112
SELECT INSTR(`�b�P`,'�') from `�s�P�O`;
113
SELECT INSTR(`�b�P`,'�') from `�s�P�O`;
114
SELECT INSTR(`�b�P`,'�') from `�s�P�O`;
115
SELECT INSTR(`�b�P`,'��') from `�s�P�P`;
116
SELECT INSTR(`�b�P`,'��') from `�s�P�P`;
117
SELECT INSTR(`�b�P`,'��') from `�s�P�P`;
118
SELECT INSTR(`�b�P`,'��') from `�s�P�P`;
119
SELECT INSTR(`�b�P`,'��') from `�s�P�P`;
120
SELECT INSTR(`�b�P`,'��') from `�s�P�P`;
121
SELECT INSTR(`�b�P`,'�\') from `�s�P�Q`;
122
SELECT INSTR(`�b�P`,'�\') from `�s�P�Q`;
123
SELECT INSTR(`�b�P`,'�\') from `�s�P�Q`;
124
SELECT INSTR(`�b�P`,'�\') from `�s�P�Q`;
125
SELECT INSTR(`�b�P`,'�\') from `�s�P�Q`;
126
SELECT INSTR(`�b�P`,'�\') from `�s�P�Q`;