1
drop table if exists `T1`;
2
drop table if exists `T2`;
3
drop table if exists `T3`;
4
drop table if exists `T4`;
5
drop table if exists `T5`;
6
drop table if exists `T6`;
7
drop table if exists `T7`;
8
drop table if exists `T8`;
9
drop table if exists `T9`;
10
drop table if exists `T10`;
12
SET character_set_database = utf8;
13
CREATE TABLE `T1` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
14
CREATE TABLE `T2` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
15
CREATE TABLE `T3` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
16
CREATE TABLE `T4` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
17
CREATE TABLE `T5` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
18
CREATE TABLE `T6` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
19
CREATE TABLE `T7` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
20
CREATE TABLE `T8` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
21
CREATE TABLE `T9` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
22
CREATE TABLE `T10` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
23
CREATE TABLE `T11` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
24
CREATE TABLE `T12` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
25
INSERT INTO `T1` VALUES ('アイウエオ');
26
INSERT INTO `T2` VALUES ('あいうえお');
27
INSERT INTO `T3` VALUES ('龔龖龗龞龡');
28
INSERT INTO `T4` VALUES ('アイウエオ');
29
INSERT INTO `T5` VALUES ('あいうえお');
30
INSERT INTO `T6` VALUES ('龔龖龗龞龡');
31
INSERT INTO `T7` VALUES ('アイウエオ');
32
INSERT INTO `T8` VALUES ('あいうえお');
33
INSERT INTO `T9` VALUES ('龔龖龗龞龡');
34
INSERT INTO `T10` VALUES ('アイウエオ');
35
INSERT INTO `T11` VALUES ('あいうえお');
36
INSERT INTO `T12` VALUES ('龔龖龗龞龡');
37
SELECT INSTR(`C1`,'ア') from `T1`;
40
SELECT INSTR(`C1`,'イ') from `T1`;
43
SELECT INSTR(`C1`,'ウ') from `T1`;
46
SELECT INSTR(`C1`,'エ') from `T1`;
49
SELECT INSTR(`C1`,'オ') from `T1`;
52
SELECT INSTR(`C1`,'ン') from `T1`;
55
SELECT INSTR(`C1`,'あ') from `T2`;
58
SELECT INSTR(`C1`,'い') from `T2`;
61
SELECT INSTR(`C1`,'う') from `T2`;
64
SELECT INSTR(`C1`,'え') from `T2`;
67
SELECT INSTR(`C1`,'お') from `T2`;
70
SELECT INSTR(`C1`,'ん') from `T2`;
73
SELECT INSTR(`C1`,'龔') from `T3`;
76
SELECT INSTR(`C1`,'龖') from `T3`;
79
SELECT INSTR(`C1`,'龗') from `T3`;
82
SELECT INSTR(`C1`,'龞') from `T3`;
85
SELECT INSTR(`C1`,'龡') from `T3`;
88
SELECT INSTR(`C1`,'丂') from `T3`;
91
SELECT INSTR(`C1`,'ア') from `T4`;
94
SELECT INSTR(`C1`,'イ') from `T4`;
97
SELECT INSTR(`C1`,'ウ') from `T4`;
100
SELECT INSTR(`C1`,'エ') from `T4`;
103
SELECT INSTR(`C1`,'オ') from `T4`;
106
SELECT INSTR(`C1`,'ン') from `T4`;
109
SELECT INSTR(`C1`,'あ') from `T5`;
112
SELECT INSTR(`C1`,'い') from `T5`;
115
SELECT INSTR(`C1`,'う') from `T5`;
118
SELECT INSTR(`C1`,'え') from `T5`;
121
SELECT INSTR(`C1`,'お') from `T5`;
124
SELECT INSTR(`C1`,'ん') from `T5`;
127
SELECT INSTR(`C1`,'龔') from `T6`;
130
SELECT INSTR(`C1`,'龖') from `T6`;
133
SELECT INSTR(`C1`,'龗') from `T6`;
136
SELECT INSTR(`C1`,'龞') from `T6`;
139
SELECT INSTR(`C1`,'龡') from `T6`;
142
SELECT INSTR(`C1`,'丂') from `T6`;
145
SELECT INSTR(`C1`,'ア') from `T7`;
148
SELECT INSTR(`C1`,'イ') from `T7`;
151
SELECT INSTR(`C1`,'ウ') from `T7`;
154
SELECT INSTR(`C1`,'エ') from `T7`;
157
SELECT INSTR(`C1`,'オ') from `T7`;
160
SELECT INSTR(`C1`,'ン') from `T7`;
163
SELECT INSTR(`C1`,'あ') from `T8`;
166
SELECT INSTR(`C1`,'い') from `T8`;
169
SELECT INSTR(`C1`,'う') from `T8`;
172
SELECT INSTR(`C1`,'え') from `T8`;
175
SELECT INSTR(`C1`,'お') from `T8`;
178
SELECT INSTR(`C1`,'ん') from `T8`;
181
SELECT INSTR(`C1`,'龔') from `T9`;
184
SELECT INSTR(`C1`,'龖') from `T9`;
187
SELECT INSTR(`C1`,'龗') from `T9`;
190
SELECT INSTR(`C1`,'龞') from `T9`;
193
SELECT INSTR(`C1`,'龡') from `T9`;
196
SELECT INSTR(`C1`,'丂') from `T9`;
199
SELECT INSTR(`C1`,'ア') from `T10`;
202
SELECT INSTR(`C1`,'イ') from `T10`;
205
SELECT INSTR(`C1`,'ウ') from `T10`;
208
SELECT INSTR(`C1`,'エ') from `T10`;
211
SELECT INSTR(`C1`,'オ') from `T10`;
214
SELECT INSTR(`C1`,'ン') from `T10`;
217
SELECT INSTR(`C1`,'あ') from `T11`;
220
SELECT INSTR(`C1`,'い') from `T11`;
223
SELECT INSTR(`C1`,'う') from `T11`;
226
SELECT INSTR(`C1`,'え') from `T11`;
229
SELECT INSTR(`C1`,'お') from `T11`;
232
SELECT INSTR(`C1`,'ん') from `T11`;
235
SELECT INSTR(`C1`,'龔') from `T12`;
238
SELECT INSTR(`C1`,'龖') from `T12`;
241
SELECT INSTR(`C1`,'龗') from `T12`;
244
SELECT INSTR(`C1`,'龞') from `T12`;
247
SELECT INSTR(`C1`,'龡') from `T12`;
250
SELECT INSTR(`C1`,'丂') from `T12`;