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