1 drop table if exists `‚s‚P`;
2 drop table if exists `‚s‚Q`;
3 drop table if exists `‚s‚R`;
4 drop table if exists `‚s‚S`;
5 drop table if exists `‚s‚T`;
6 drop table if exists `‚s‚U`;
7 drop table if exists `‚s‚V`;
8 drop table if exists `‚s‚W`;
9 drop table if exists `‚s‚X`;
11 SET character_set_database = sjis;
12 CREATE TABLE `‚s‚P` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
13 CREATE TABLE `‚s‚Q` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
14 CREATE TABLE `‚s‚R` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
15 CREATE TABLE `‚s‚S` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
16 CREATE TABLE `‚s‚T` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
17 CREATE TABLE `‚s‚U` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
18 CREATE TABLE `‚s‚V` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
19 CREATE TABLE `‚s‚W` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
20 CREATE TABLE `‚s‚X` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
21 INSERT INTO `‚s‚P` VALUES ('±²³´µ');
22 INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨');
23 INSERT INTO `‚s‚R` VALUES ('ƒ\�\•\—\�\');
24 INSERT INTO `‚s‚S` VALUES ('±²³´µ');
25 INSERT INTO `‚s‚T` VALUES ('‚ ‚¢‚¤‚¦‚¨');
26 INSERT INTO `‚s‚U` VALUES ('ƒ\�\•\—\�\');
27 INSERT INTO `‚s‚V` VALUES ('±²³´µ');
28 INSERT INTO `‚s‚W` VALUES ('‚ ‚¢‚¤‚¦‚¨');
29 INSERT INTO `‚s‚X` VALUES ('ƒ\�\•\—\�\');
30 SELECT LOCATE('±',`‚b‚P`) from `‚s‚P`;
33 SELECT LOCATE('²',`‚b‚P`) from `‚s‚P`;
36 SELECT LOCATE('³',`‚b‚P`) from `‚s‚P`;
39 SELECT LOCATE('´',`‚b‚P`) from `‚s‚P`;
42 SELECT LOCATE('µ',`‚b‚P`) from `‚s‚P`;
45 SELECT LOCATE('Ý',`‚b‚P`) from `‚s‚P`;
48 SELECT LOCATE('‚ ',`‚b‚P`) from `‚s‚Q`;
51 SELECT LOCATE('‚¢',`‚b‚P`) from `‚s‚Q`;
54 SELECT LOCATE('‚¤',`‚b‚P`) from `‚s‚Q`;
57 SELECT LOCATE('‚¦',`‚b‚P`) from `‚s‚Q`;
60 SELECT LOCATE('‚¨',`‚b‚P`) from `‚s‚Q`;
63 SELECT LOCATE('‚ñ',`‚b‚P`) from `‚s‚Q`;
66 SELECT LOCATE('ƒ\',`‚b‚P`) from `‚s‚R`;
69 SELECT LOCATE('�\',`‚b‚P`) from `‚s‚R`;
72 SELECT LOCATE('•\',`‚b‚P`) from `‚s‚R`;
75 SELECT LOCATE('—\',`‚b‚P`) from `‚s‚R`;
78 SELECT LOCATE('�\',`‚b‚P`) from `‚s‚R`;
81 SELECT LOCATE('‰\',`‚b‚P`) from `‚s‚R`;
84 SELECT LOCATE('±',`‚b‚P`) from `‚s‚S`;
87 SELECT LOCATE('²',`‚b‚P`) from `‚s‚S`;
90 SELECT LOCATE('³',`‚b‚P`) from `‚s‚S`;
93 SELECT LOCATE('´',`‚b‚P`) from `‚s‚S`;
96 SELECT LOCATE('µ',`‚b‚P`) from `‚s‚S`;
99 SELECT LOCATE('Ý',`‚b‚P`) from `‚s‚S`;
102 SELECT LOCATE('‚ ',`‚b‚P`) from `‚s‚T`;
105 SELECT LOCATE('‚¢',`‚b‚P`) from `‚s‚T`;
108 SELECT LOCATE('‚¤',`‚b‚P`) from `‚s‚T`;
111 SELECT LOCATE('‚¦',`‚b‚P`) from `‚s‚T`;
114 SELECT LOCATE('‚¨',`‚b‚P`) from `‚s‚T`;
117 SELECT LOCATE('‚ñ',`‚b‚P`) from `‚s‚T`;
120 SELECT LOCATE('ƒ\',`‚b‚P`) from `‚s‚U`;
123 SELECT LOCATE('�\',`‚b‚P`) from `‚s‚U`;
126 SELECT LOCATE('•\',`‚b‚P`) from `‚s‚U`;
129 SELECT LOCATE('—\',`‚b‚P`) from `‚s‚U`;
132 SELECT LOCATE('�\',`‚b‚P`) from `‚s‚U`;
135 SELECT LOCATE('‰\',`‚b‚P`) from `‚s‚U`;
138 SELECT LOCATE('±',`‚b‚P`) from `‚s‚V`;
141 SELECT LOCATE('²',`‚b‚P`) from `‚s‚V`;
144 SELECT LOCATE('³',`‚b‚P`) from `‚s‚V`;
147 SELECT LOCATE('´',`‚b‚P`) from `‚s‚V`;
150 SELECT LOCATE('µ',`‚b‚P`) from `‚s‚V`;
153 SELECT LOCATE('Ý',`‚b‚P`) from `‚s‚V`;
156 SELECT LOCATE('‚ ',`‚b‚P`) from `‚s‚W`;
159 SELECT LOCATE('‚¢',`‚b‚P`) from `‚s‚W`;
162 SELECT LOCATE('‚¤',`‚b‚P`) from `‚s‚W`;
165 SELECT LOCATE('‚¦',`‚b‚P`) from `‚s‚W`;
168 SELECT LOCATE('‚¨',`‚b‚P`) from `‚s‚W`;
171 SELECT LOCATE('‚ñ',`‚b‚P`) from `‚s‚W`;
174 SELECT LOCATE('ƒ\',`‚b‚P`) from `‚s‚X`;
177 SELECT LOCATE('�\',`‚b‚P`) from `‚s‚X`;
180 SELECT LOCATE('•\',`‚b‚P`) from `‚s‚X`;
183 SELECT LOCATE('—\',`‚b‚P`) from `‚s‚X`;
186 SELECT LOCATE('�\',`‚b‚P`) from `‚s‚X`;
189 SELECT LOCATE('‰\',`‚b‚P`) from `‚s‚X`;