7
7
drop table if exists `�s�V`;
8
8
drop table if exists `�s�W`;
9
9
drop table if exists `�s�X`;
10
drop table if exists `�s�P�O`;
11
drop table if exists `�s�P�P`;
12
drop table if exists `�s�P�Q`;
14
11
SET character_set_database = sjis;
15
12
CREATE TABLE `�s�P` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = innodb;
18
15
CREATE TABLE `�s�S` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
19
16
CREATE TABLE `�s�T` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
20
17
CREATE TABLE `�s�U` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
21
CREATE TABLE `�s�V` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = heap;
22
CREATE TABLE `�s�W` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = heap;
23
CREATE TABLE `�s�X` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = heap;
24
CREATE TABLE `�s�P�O` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = bdb;
25
CREATE TABLE `�s�P�P` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = bdb;
26
CREATE TABLE `�s�P�Q` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = bdb;
18
CREATE TABLE `�s�V` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = MEMORY;
19
CREATE TABLE `�s�W` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = MEMORY;
20
CREATE TABLE `�s�X` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = MEMORY;
27
21
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `�s�P`;
28
22
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `�s�Q`;
29
23
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `�s�R`;
33
27
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `�s�V`;
34
28
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `�s�W`;
35
29
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `�s�X`;
36
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `�s�P�O`;
37
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `�s�P�P`;
38
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `�s�P�Q`;
39
30
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�P`;
171
162
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�X`;
172
163
CHARSET(CONVERT(`�b�P` USING ujis))
174
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�P�O`;
177
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�P�P`;
180
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�P�Q`;
183
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�P�O`;
184
CHARSET(CONVERT(`�b�P` USING utf8))
186
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�P�O`;
187
CHARSET(CONVERT(`�b�P` USING ucs2))
189
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�P�O`;
190
CHARSET(CONVERT(`�b�P` USING sjis))
192
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�P�O`;
193
CHARSET(CONVERT(`�b�P` USING ujis))
195
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�P�P`;
196
CHARSET(CONVERT(`�b�P` USING utf8))
198
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�P�P`;
199
CHARSET(CONVERT(`�b�P` USING ucs2))
201
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�P�P`;
202
CHARSET(CONVERT(`�b�P` USING sjis))
204
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�P�P`;
205
CHARSET(CONVERT(`�b�P` USING ujis))
207
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�P�Q`;
208
CHARSET(CONVERT(`�b�P` USING utf8))
210
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�P�Q`;
211
CHARSET(CONVERT(`�b�P` USING ucs2))
213
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�P�Q`;
214
CHARSET(CONVERT(`�b�P` USING sjis))
216
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�P�Q`;
217
CHARSET(CONVERT(`�b�P` USING ujis))
219
165
drop table `�s�P`;
220
166
drop table `�s�Q`;
221
167
drop table `�s�R`;