1
drop table if exists `�ԣ�`;
2
drop table if exists `�ԣ�`;
3
drop table if exists `�ԣ�`;
4
drop table if exists `�ԣ�`;
5
drop table if exists `�ԣ�`;
6
drop table if exists `�ԣ�`;
7
drop table if exists `�ԣ�`;
8
drop table if exists `�ԣ�`;
9
drop table if exists `�ԣ�`;
11
SET character_set_database = ujis;
12
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ujis engine = innodb;
13
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ujis engine = innodb;
14
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ujis engine = innodb;
15
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ujis engine = myisam;
16
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ujis engine = myisam;
17
CREATE TABLE `�ԣ�` (`�ã�` char(20)) DEFAULT CHARSET = ujis engine = myisam;
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;
21
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `�ԣ�`;
22
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `�ԣ�`;
23
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `�ԣ�`;
24
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `�ԣ�`;
25
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `�ԣ�`;
26
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `�ԣ�`;
27
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `�ԣ�`;
28
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `�ԣ�`;
29
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `�ԣ�`;
30
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
33
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
36
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
39
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
40
CHARSET(CONVERT(`�ã�` USING utf8))
42
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
43
CHARSET(CONVERT(`�ã�` USING ucs2))
45
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
46
CHARSET(CONVERT(`�ã�` USING sjis))
48
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
49
CHARSET(CONVERT(`�ã�` USING ujis))
51
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
52
CHARSET(CONVERT(`�ã�` USING utf8))
54
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
55
CHARSET(CONVERT(`�ã�` USING ucs2))
57
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
58
CHARSET(CONVERT(`�ã�` USING sjis))
60
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
61
CHARSET(CONVERT(`�ã�` USING ujis))
63
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
64
CHARSET(CONVERT(`�ã�` USING utf8))
66
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
67
CHARSET(CONVERT(`�ã�` USING ucs2))
69
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
70
CHARSET(CONVERT(`�ã�` USING sjis))
72
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
73
CHARSET(CONVERT(`�ã�` USING ujis))
75
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
78
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
81
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
84
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
85
CHARSET(CONVERT(`�ã�` USING utf8))
87
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
88
CHARSET(CONVERT(`�ã�` USING ucs2))
90
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
91
CHARSET(CONVERT(`�ã�` USING sjis))
93
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
94
CHARSET(CONVERT(`�ã�` USING ujis))
96
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
97
CHARSET(CONVERT(`�ã�` USING utf8))
99
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
100
CHARSET(CONVERT(`�ã�` USING ucs2))
102
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
103
CHARSET(CONVERT(`�ã�` USING sjis))
105
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
106
CHARSET(CONVERT(`�ã�` USING ujis))
108
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
109
CHARSET(CONVERT(`�ã�` USING utf8))
111
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
112
CHARSET(CONVERT(`�ã�` USING ucs2))
114
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
115
CHARSET(CONVERT(`�ã�` USING sjis))
117
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
118
CHARSET(CONVERT(`�ã�` USING ujis))
120
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
123
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
126
SELECT DISTINCT CHARSET(`�ã�`) FROM `�ԣ�`;
129
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
130
CHARSET(CONVERT(`�ã�` USING utf8))
132
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
133
CHARSET(CONVERT(`�ã�` USING ucs2))
135
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
136
CHARSET(CONVERT(`�ã�` USING sjis))
138
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
139
CHARSET(CONVERT(`�ã�` USING ujis))
141
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
142
CHARSET(CONVERT(`�ã�` USING utf8))
144
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
145
CHARSET(CONVERT(`�ã�` USING ucs2))
147
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
148
CHARSET(CONVERT(`�ã�` USING sjis))
150
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
151
CHARSET(CONVERT(`�ã�` USING ujis))
153
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING utf8)) FROM `�ԣ�`;
154
CHARSET(CONVERT(`�ã�` USING utf8))
156
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ucs2)) FROM `�ԣ�`;
157
CHARSET(CONVERT(`�ã�` USING ucs2))
159
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING sjis)) FROM `�ԣ�`;
160
CHARSET(CONVERT(`�ã�` USING sjis))
162
SELECT DISTINCT CHARSET(CONVERT(`�ã�` USING ujis)) FROM `�ԣ�`;
163
CHARSET(CONVERT(`�ã�` USING ujis))