| blob | 0d9cfff55571a72acbe6351aba64af9a5c3d30d0 |
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`;
10 SET NAMES sjis;
11 SET character_set_database = sjis;
12 CREATE TABLE `‚s‚P` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
13 CREATE TABLE `‚s‚Q` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
14 CREATE TABLE `‚s‚R` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
15 CREATE TABLE `‚s‚S` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
16 CREATE TABLE `‚s‚T` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
17 CREATE TABLE `‚s‚U` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
18 CREATE TABLE `‚s‚V` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
19 CREATE TABLE `‚s‚W` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
20 CREATE TABLE `‚s‚X` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
21 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚P`;
22 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚Q`;
23 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚R`;
24 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚S`;
25 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚T`;
26 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚U`;
27 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚V`;
28 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚W`;
29 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚X`;
30 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE ' %';
31 ‚b‚P
32 !"#$%&'()*+,-./
33 ¡¢£¤¥¦§¨©ª«¬®¯
34 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '% %';
35 ‚b‚P
36 !"#$%&'()*+,-./
37 ¡¢£¤¥¦§¨©ª«¬®¯
38 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '% ';
39 ‚b‚P
40 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE 'À%';
41 ‚b‚P
42 ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
43 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%×Ø%';
44 ‚b‚P
45 ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß
46 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%¿';
47 ‚b‚P
48 °±²³´µ¶·¸¹º»¼½¾¿
49 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '°±²³´µ¶·¸¹º»¼½¾¿%';
50 ‚b‚P
51 °±²³´µ¶·¸¹º»¼½¾¿
52 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿%';
53 ‚b‚P
54 °±²³´µ¶·¸¹º»¼½¾¿
55 SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿';
56 ‚b‚P
57 °±²³´µ¶·¸¹º»¼½¾¿
58 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '�@%';
59 ‚b‚P
60 �@�@�A�B�C�D�E�F�G�H�I�J�K�L�M�N�O�P�Q�R
61 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%�@%';
62 ‚b‚P
63 �@�@�A�B�C�D�E�F�G�H�I�J�K�L�M�N�O�P�Q�R
64 �E�E�ð�ñ�ò�ó�ô�õ�ö�÷�E�E�E�E�ü�E�E�E�E�@
65 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%�@';
66 ‚b‚P
67 �E�E�ð�ñ�ò�ó�ô�õ�ö�÷�E�E�E�E�ü�E�E�E�E�@
68 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '‚Æ%';
69 ‚b‚P
70 ‚ƂǂȂɂʂ˂̂͂΂ςЂт҂ӂԂՂւׂ؂Ù
71 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%‚ %';
72 ‚b‚P
73 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
74 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%‚í';
75 ‚b‚P
76 ‚Ú‚Û‚Ü‚Ý‚Þ‚ß‚à‚á‚â‚ã‚ä‚å‚æ‚ç‚è‚é‚ê‚ë‚ì‚í
77 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±%';
78 ‚b‚P
79 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
80 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±%';
81 ‚b‚P
82 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
83 SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±';
84 ‚b‚P
85 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
86 SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE 'ƒ\%';
87 ‚b‚P
88 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
89 SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%–\%';
90 ‚b‚P
91 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
92 SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%ž\';
93 ‚b‚P
94 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
95 SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE 'ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\%';
96 ‚b‚P
97 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
98 SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\%';
99 ‚b‚P
100 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
101 SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\';
102 ‚b‚P
103 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
104 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE ' %';
105 ‚b‚P
106 !"#$%&'()*+,-./
107 ¡¢£¤¥¦§¨©ª«¬®¯
108 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '% %';
109 ‚b‚P
110 !"#$%&'()*+,-./
111 ¡¢£¤¥¦§¨©ª«¬®¯
112 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '% ';
113 ‚b‚P
114 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE 'À%';
115 ‚b‚P
116 ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
117 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%×Ø%';
118 ‚b‚P
119 ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß
120 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%¿';
121 ‚b‚P
122 °±²³´µ¶·¸¹º»¼½¾¿
123 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '°±²³´µ¶·¸¹º»¼½¾¿%';
124 ‚b‚P
125 °±²³´µ¶·¸¹º»¼½¾¿
126 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿%';
127 ‚b‚P
128 °±²³´µ¶·¸¹º»¼½¾¿
129 SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿';
130 ‚b‚P
131 °±²³´µ¶·¸¹º»¼½¾¿
132 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '�@%';
133 ‚b‚P
134 �@�@�A�B�C�D�E�F�G�H�I�J�K�L�M�N�O�P�Q�R
135 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%�@%';
136 ‚b‚P
137 �@�@�A�B�C�D�E�F�G�H�I�J�K�L�M�N�O�P�Q�R
138 �E�E�ð�ñ�ò�ó�ô�õ�ö�÷�E�E�E�E�ü�E�E�E�E�@
139 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%�@';
140 ‚b‚P
141 �E�E�ð�ñ�ò�ó�ô�õ�ö�÷�E�E�E�E�ü�E�E�E�E�@
142 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '‚Æ%';
143 ‚b‚P
144 ‚ƂǂȂɂʂ˂̂͂΂ςЂт҂ӂԂՂւׂ؂Ù
145 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%‚ %';
146 ‚b‚P
147 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
148 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%‚í';
149 ‚b‚P
150 ‚Ú‚Û‚Ü‚Ý‚Þ‚ß‚à‚á‚â‚ã‚ä‚å‚æ‚ç‚è‚é‚ê‚ë‚ì‚í
151 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±%';
152 ‚b‚P
153 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
154 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±%';
155 ‚b‚P
156 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
157 SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±';
158 ‚b‚P
159 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
160 SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE 'ƒ\%';
161 ‚b‚P
162 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
163 SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%–\%';
164 ‚b‚P
165 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
166 SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%ž\';
167 ‚b‚P
168 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
169 SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE 'ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\%';
170 ‚b‚P
171 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
172 SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\%';
173 ‚b‚P
174 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
175 SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\';
176 ‚b‚P
177 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
178 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE ' %';
179 ‚b‚P
180 !"#$%&'()*+,-./
181 ¡¢£¤¥¦§¨©ª«¬®¯
182 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '% %';
183 ‚b‚P
184 !"#$%&'()*+,-./
185 ¡¢£¤¥¦§¨©ª«¬®¯
186 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '% ';
187 ‚b‚P
188 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE 'À%';
189 ‚b‚P
190 ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
191 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%×Ø%';
192 ‚b‚P
193 ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß
194 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%¿';
195 ‚b‚P
196 °±²³´µ¶·¸¹º»¼½¾¿
197 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '°±²³´µ¶·¸¹º»¼½¾¿%';
198 ‚b‚P
199 °±²³´µ¶·¸¹º»¼½¾¿
200 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿%';
201 ‚b‚P
202 °±²³´µ¶·¸¹º»¼½¾¿
203 SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%°±²³´µ¶·¸¹º»¼½¾¿';
204 ‚b‚P
205 °±²³´µ¶·¸¹º»¼½¾¿
206 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '�@%';
207 ‚b‚P
208 �@�@�A�B�C�D�E�F�G�H�I�J�K�L�M�N�O�P�Q�R
209 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%�@%';
210 ‚b‚P
211 �@�@�A�B�C�D�E�F�G�H�I�J�K�L�M�N�O�P�Q�R
212 �E�E�ð�ñ�ò�ó�ô�õ�ö�÷�E�E�E�E�ü�E�E�E�E�@
213 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%�@';
214 ‚b‚P
215 �E�E�ð�ñ�ò�ó�ô�õ�ö�÷�E�E�E�E�ü�E�E�E�E�@
216 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '‚Æ%';
217 ‚b‚P
218 ‚ƂǂȂɂʂ˂̂͂΂ςЂт҂ӂԂՂւׂ؂Ù
219 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%‚ %';
220 ‚b‚P
221 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
222 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%‚í';
223 ‚b‚P
224 ‚Ú‚Û‚Ü‚Ý‚Þ‚ß‚à‚á‚â‚ã‚ä‚å‚æ‚ç‚è‚é‚ê‚ë‚ì‚í
225 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±%';
226 ‚b‚P
227 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
228 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±%';
229 ‚b‚P
230 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
231 SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%�E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±';
232 ‚b‚P
233 �E‚Ÿ‚ ‚¡‚¢‚£‚¤‚¥‚¦‚§‚¨‚©‚ª‚«‚¬‚‚®‚¯‚°‚±
234 SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE 'ƒ\%';
235 ‚b‚P
236 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
237 SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%–\%';
238 ‚b‚P
239 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
240 SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%ž\';
241 ‚b‚P
242 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
243 SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE 'ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\%';
244 ‚b‚P
245 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
246 SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\%';
247 ‚b‚P
248 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
249 SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\';
250 ‚b‚P
251 ƒ\�\•\—\�\‰\Ž\�\“\”\–\˜\‘\’\™\š\›\œ\�\ž\
252 DROP TABLE `‚s‚P`;
253 DROP TABLE `‚s‚Q`;
254 DROP TABLE `‚s‚R`;
255 DROP TABLE `‚s‚S`;
256 DROP TABLE `‚s‚T`;
257 DROP TABLE `‚s‚U`;
258 DROP TABLE `‚s‚V`;
259 DROP TABLE `‚s‚W`;
260 DROP TABLE `‚s‚X`;