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)) DEFAULT CHARSET = sjis engine = innodb;
13 CREATE TABLE `‚s‚Q` (`‚b‚P` char(5)) DEFAULT CHARSET = sjis engine = innodb;
14 CREATE TABLE `‚s‚R` (`‚b‚P` char(5)) DEFAULT CHARSET = sjis engine = innodb;
15 CREATE TABLE `‚s‚S` (`‚b‚P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
16 CREATE TABLE `‚s‚T` (`‚b‚P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
17 CREATE TABLE `‚s‚U` (`‚b‚P` char(5)) DEFAULT CHARSET = sjis engine = myisam;
18 CREATE TABLE `‚s‚V` (`‚b‚P` char(5)) DEFAULT CHARSET = sjis engine = MEMORY;
19 CREATE TABLE `‚s‚W` (`‚b‚P` char(5)) DEFAULT CHARSET = sjis engine = MEMORY;
20 CREATE TABLE `‚s‚X` (`‚b‚P` char(5)) 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 REPLACE(`‚b‚P`,'±','±±') FROM `‚s‚P`;
31 REPLACE(`‚b‚P`,'±','±±')
33 SELECT REPLACE(`‚b‚P`,'²','²²') FROM `‚s‚P`;
34 REPLACE(`‚b‚P`,'²','²²')
36 SELECT REPLACE(`‚b‚P`,'³','³³') FROM `‚s‚P`;
37 REPLACE(`‚b‚P`,'³','³³')
39 SELECT REPLACE(`‚b‚P`,'´','´´') FROM `‚s‚P`;
40 REPLACE(`‚b‚P`,'´','´´')
42 SELECT REPLACE(`‚b‚P`,'µ','µµ') FROM `‚s‚P`;
43 REPLACE(`‚b‚P`,'µ','µµ')
45 SELECT REPLACE(`‚b‚P`,'‚ ','‚ ‚ ') FROM `‚s‚Q`;
46 REPLACE(`‚b‚P`,'‚ ','‚ ‚ ')
48 SELECT REPLACE(`‚b‚P`,'‚¢','‚¢‚¢') FROM `‚s‚Q`;
49 REPLACE(`‚b‚P`,'‚¢','‚¢‚¢')
51 SELECT REPLACE(`‚b‚P`,'‚¤','‚¤‚¤') FROM `‚s‚Q`;
52 REPLACE(`‚b‚P`,'‚¤','‚¤‚¤')
54 SELECT REPLACE(`‚b‚P`,'‚¦','‚¦‚¦') FROM `‚s‚Q`;
55 REPLACE(`‚b‚P`,'‚¦','‚¦‚¦')
57 SELECT REPLACE(`‚b‚P`,'‚¨','‚¨‚¨') FROM `‚s‚Q`;
58 REPLACE(`‚b‚P`,'‚¨','‚¨‚¨')
60 SELECT REPLACE(`‚b‚P`,'ƒ\','ƒ\ƒ\') FROM `‚s‚R`;
61 REPLACE(`‚b‚P`,'ƒ\','ƒ\ƒ\')
63 SELECT REPLACE(`‚b‚P`,'�\','�\�\') FROM `‚s‚R`;
64 REPLACE(`‚b‚P`,'�\','�\�\')
66 SELECT REPLACE(`‚b‚P`,'•\','•\•\') FROM `‚s‚R`;
67 REPLACE(`‚b‚P`,'•\','•\•\')
69 SELECT REPLACE(`‚b‚P`,'—\','—\—\') FROM `‚s‚R`;
70 REPLACE(`‚b‚P`,'—\','—\—\')
72 SELECT REPLACE(`‚b‚P`,'�\','�\�\') FROM `‚s‚R`;
73 REPLACE(`‚b‚P`,'�\','�\�\')
75 SELECT REPLACE(`‚b‚P`,'±','±±') FROM `‚s‚S`;
76 REPLACE(`‚b‚P`,'±','±±')
78 SELECT REPLACE(`‚b‚P`,'²','²²') FROM `‚s‚S`;
79 REPLACE(`‚b‚P`,'²','²²')
81 SELECT REPLACE(`‚b‚P`,'³','³³') FROM `‚s‚S`;
82 REPLACE(`‚b‚P`,'³','³³')
84 SELECT REPLACE(`‚b‚P`,'´','´´') FROM `‚s‚S`;
85 REPLACE(`‚b‚P`,'´','´´')
87 SELECT REPLACE(`‚b‚P`,'µ','µµ') FROM `‚s‚S`;
88 REPLACE(`‚b‚P`,'µ','µµ')
90 SELECT REPLACE(`‚b‚P`,'‚ ','‚ ‚ ') FROM `‚s‚T`;
91 REPLACE(`‚b‚P`,'‚ ','‚ ‚ ')
93 SELECT REPLACE(`‚b‚P`,'‚¢','‚¢‚¢') FROM `‚s‚T`;
94 REPLACE(`‚b‚P`,'‚¢','‚¢‚¢')
96 SELECT REPLACE(`‚b‚P`,'‚¤','‚¤‚¤') FROM `‚s‚T`;
97 REPLACE(`‚b‚P`,'‚¤','‚¤‚¤')
99 SELECT REPLACE(`‚b‚P`,'‚¦','‚¦‚¦') FROM `‚s‚T`;
100 REPLACE(`‚b‚P`,'‚¦','‚¦‚¦')
102 SELECT REPLACE(`‚b‚P`,'‚¨','‚¨‚¨') FROM `‚s‚T`;
103 REPLACE(`‚b‚P`,'‚¨','‚¨‚¨')
105 SELECT REPLACE(`‚b‚P`,'ƒ\','ƒ\ƒ\') FROM `‚s‚U`;
106 REPLACE(`‚b‚P`,'ƒ\','ƒ\ƒ\')
108 SELECT REPLACE(`‚b‚P`,'�\','�\�\') FROM `‚s‚U`;
109 REPLACE(`‚b‚P`,'�\','�\�\')
111 SELECT REPLACE(`‚b‚P`,'•\','•\•\') FROM `‚s‚U`;
112 REPLACE(`‚b‚P`,'•\','•\•\')
114 SELECT REPLACE(`‚b‚P`,'—\','—\—\') FROM `‚s‚U`;
115 REPLACE(`‚b‚P`,'—\','—\—\')
117 SELECT REPLACE(`‚b‚P`,'�\','�\�\') FROM `‚s‚U`;
118 REPLACE(`‚b‚P`,'�\','�\�\')
120 SELECT REPLACE(`‚b‚P`,'±','±±') FROM `‚s‚V`;
121 REPLACE(`‚b‚P`,'±','±±')
123 SELECT REPLACE(`‚b‚P`,'²','²²') FROM `‚s‚V`;
124 REPLACE(`‚b‚P`,'²','²²')
126 SELECT REPLACE(`‚b‚P`,'³','³³') FROM `‚s‚V`;
127 REPLACE(`‚b‚P`,'³','³³')
129 SELECT REPLACE(`‚b‚P`,'´','´´') FROM `‚s‚V`;
130 REPLACE(`‚b‚P`,'´','´´')
132 SELECT REPLACE(`‚b‚P`,'µ','µµ') FROM `‚s‚V`;
133 REPLACE(`‚b‚P`,'µ','µµ')
135 SELECT REPLACE(`‚b‚P`,'‚ ','‚ ‚ ') FROM `‚s‚W`;
136 REPLACE(`‚b‚P`,'‚ ','‚ ‚ ')
138 SELECT REPLACE(`‚b‚P`,'‚¢','‚¢‚¢') FROM `‚s‚W`;
139 REPLACE(`‚b‚P`,'‚¢','‚¢‚¢')
141 SELECT REPLACE(`‚b‚P`,'‚¤','‚¤‚¤') FROM `‚s‚W`;
142 REPLACE(`‚b‚P`,'‚¤','‚¤‚¤')
144 SELECT REPLACE(`‚b‚P`,'‚¦','‚¦‚¦') FROM `‚s‚W`;
145 REPLACE(`‚b‚P`,'‚¦','‚¦‚¦')
147 SELECT REPLACE(`‚b‚P`,'‚¨','‚¨‚¨') FROM `‚s‚W`;
148 REPLACE(`‚b‚P`,'‚¨','‚¨‚¨')
150 SELECT REPLACE(`‚b‚P`,'ƒ\','ƒ\ƒ\') FROM `‚s‚X`;
151 REPLACE(`‚b‚P`,'ƒ\','ƒ\ƒ\')
153 SELECT REPLACE(`‚b‚P`,'�\','�\�\') FROM `‚s‚X`;
154 REPLACE(`‚b‚P`,'�\','�\�\')
156 SELECT REPLACE(`‚b‚P`,'•\','•\•\') FROM `‚s‚X`;
157 REPLACE(`‚b‚P`,'•\','•\•\')
159 SELECT REPLACE(`‚b‚P`,'—\','—\—\') FROM `‚s‚X`;
160 REPLACE(`‚b‚P`,'—\','—\—\')
162 SELECT REPLACE(`‚b‚P`,'�\','�\�\') FROM `‚s‚X`;
163 REPLACE(`‚b‚P`,'�\','�\�\')