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(20)) DEFAULT CHARSET = sjis engine = innodb;
13
CREATE TABLE `�s�Q` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = innodb;
14
CREATE TABLE `�s�R` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = innodb;
15
CREATE TABLE `�s�S` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
16
CREATE TABLE `�s�T` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
17
CREATE TABLE `�s�U` (`�b�P` char(20)) DEFAULT CHARSET = sjis engine = myisam;
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;
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 DISTINCT CHARSET(`�b�P`) FROM `�s�P`;
33
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�Q`;
36
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�R`;
39
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�P`;
40
CHARSET(CONVERT(`�b�P` USING utf8))
42
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�P`;
43
CHARSET(CONVERT(`�b�P` USING ucs2))
45
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�P`;
46
CHARSET(CONVERT(`�b�P` USING sjis))
48
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�P`;
49
CHARSET(CONVERT(`�b�P` USING ujis))
51
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�Q`;
52
CHARSET(CONVERT(`�b�P` USING utf8))
54
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�Q`;
55
CHARSET(CONVERT(`�b�P` USING ucs2))
57
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�Q`;
58
CHARSET(CONVERT(`�b�P` USING sjis))
60
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�Q`;
61
CHARSET(CONVERT(`�b�P` USING ujis))
63
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�R`;
64
CHARSET(CONVERT(`�b�P` USING utf8))
66
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�R`;
67
CHARSET(CONVERT(`�b�P` USING ucs2))
69
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�R`;
70
CHARSET(CONVERT(`�b�P` USING sjis))
72
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�R`;
73
CHARSET(CONVERT(`�b�P` USING ujis))
75
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�S`;
78
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�T`;
81
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�U`;
84
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�S`;
85
CHARSET(CONVERT(`�b�P` USING utf8))
87
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�S`;
88
CHARSET(CONVERT(`�b�P` USING ucs2))
90
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�S`;
91
CHARSET(CONVERT(`�b�P` USING sjis))
93
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�S`;
94
CHARSET(CONVERT(`�b�P` USING ujis))
96
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�T`;
97
CHARSET(CONVERT(`�b�P` USING utf8))
99
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�T`;
100
CHARSET(CONVERT(`�b�P` USING ucs2))
102
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�T`;
103
CHARSET(CONVERT(`�b�P` USING sjis))
105
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�T`;
106
CHARSET(CONVERT(`�b�P` USING ujis))
108
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�U`;
109
CHARSET(CONVERT(`�b�P` USING utf8))
111
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�U`;
112
CHARSET(CONVERT(`�b�P` USING ucs2))
114
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�U`;
115
CHARSET(CONVERT(`�b�P` USING sjis))
117
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�U`;
118
CHARSET(CONVERT(`�b�P` USING ujis))
120
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�V`;
123
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�W`;
126
SELECT DISTINCT CHARSET(`�b�P`) FROM `�s�X`;
129
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�V`;
130
CHARSET(CONVERT(`�b�P` USING utf8))
132
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�V`;
133
CHARSET(CONVERT(`�b�P` USING ucs2))
135
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�V`;
136
CHARSET(CONVERT(`�b�P` USING sjis))
138
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�V`;
139
CHARSET(CONVERT(`�b�P` USING ujis))
141
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�W`;
142
CHARSET(CONVERT(`�b�P` USING utf8))
144
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�W`;
145
CHARSET(CONVERT(`�b�P` USING ucs2))
147
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�W`;
148
CHARSET(CONVERT(`�b�P` USING sjis))
150
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�W`;
151
CHARSET(CONVERT(`�b�P` USING ujis))
153
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING utf8)) FROM `�s�X`;
154
CHARSET(CONVERT(`�b�P` USING utf8))
156
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ucs2)) FROM `�s�X`;
157
CHARSET(CONVERT(`�b�P` USING ucs2))
159
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING sjis)) FROM `�s�X`;
160
CHARSET(CONVERT(`�b�P` USING sjis))
162
SELECT DISTINCT CHARSET(CONVERT(`�b�P` USING ujis)) FROM `�s�X`;
163
CHARSET(CONVERT(`�b�P` USING ujis))