~drizzle-trunk/drizzle/development : contents of test/suite/jp/r/jp_charset

~drizzle-trunk/drizzle/development : (revision 77.1.46)

drop table if exists `sP`;
drop table if exists `sQ`;
drop table if exists `sR`;
drop table if exists `sS`;
drop table if exists `sT`;
drop table if exists `sU`;
drop table if exists `sV`;
drop table if exists `sW`;
drop table if exists `sX`;
drop table if exists `sPO`;
drop table if exists `sPP`;
drop table if exists `sPQ`;
SET NAMES sjis;
SET character_set_database = sjis;
CREATE TABLE `sP` (`bP` char(20)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sQ` (`bP` char(20)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sR` (`bP` char(20)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sS` (`bP` char(20)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sT` (`bP` char(20)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sU` (`bP` char(20)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sV` (`bP` char(20)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sW` (`bP` char(20)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sX` (`bP` char(20)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sPO` (`bP` char(20)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPP` (`bP` char(20)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPQ` (`bP` char(20)) DEFAULT CHARSET = sjis engine = bdb;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sP`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sQ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sR`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sS`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sT`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sU`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sV`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sW`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sX`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sPO`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sPP`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sPQ`;
SELECT DISTINCT CHARSET(`bP`) FROM `sP`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(`bP`) FROM `sQ`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(`bP`) FROM `sR`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sP`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sP`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sP`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sP`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sQ`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sQ`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sQ`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sQ`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sR`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sR`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sR`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sR`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(`bP`) FROM `sS`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(`bP`) FROM `sT`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(`bP`) FROM `sU`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sS`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sS`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sS`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sS`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sT`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sT`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sT`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sT`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sU`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sU`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sU`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sU`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(`bP`) FROM `sV`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(`bP`) FROM `sW`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(`bP`) FROM `sX`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sV`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sV`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sV`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sV`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sW`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sW`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sW`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sW`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sX`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sX`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sX`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sX`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(`bP`) FROM `sPO`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(`bP`) FROM `sPP`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(`bP`) FROM `sPQ`;
CHARSET(`bP`)
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sPO`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sPO`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sPO`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sPO`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sPP`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sPP`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sPP`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sPP`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sPQ`;
CHARSET(CONVERT(`bP` USING utf8))
utf8
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sPQ`;
CHARSET(CONVERT(`bP` USING ucs2))
ucs2
SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sPQ`;
CHARSET(CONVERT(`bP` USING sjis))
sjis
SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sPQ`;
CHARSET(CONVERT(`bP` USING ujis))
ujis
drop table `sP`;
drop table `sQ`;
drop table `sR`;
drop table `sS`;
drop table `sT`;
drop table `sU`;
drop table `sV`;
drop table `sW`;
drop table `sX`;
drop table `sPO`;
drop table `sPP`;
drop table `sPQ`;

1 by brian clean slate	1	drop table if exists `sP`;
	2	drop table if exists `sQ`;
	3	drop table if exists `sR`;
	4	drop table if exists `sS`;
	5	drop table if exists `sT`;
	6	drop table if exists `sU`;
	7	drop table if exists `sV`;
	8	drop table if exists `sW`;
	9	drop table if exists `sX`;
	10	drop table if exists `sPO`;
	11	drop table if exists `sPP`;
	12	drop table if exists `sPQ`;
	13	SET NAMES sjis;
	14	SET character_set_database = sjis;
	15	CREATE TABLE `sP` (`bP` char(20)) DEFAULT CHARSET = sjis engine = innodb;
	16	CREATE TABLE `sQ` (`bP` char(20)) DEFAULT CHARSET = sjis engine = innodb;
	17	CREATE TABLE `sR` (`bP` char(20)) DEFAULT CHARSET = sjis engine = innodb;
	18	CREATE TABLE `sS` (`bP` char(20)) DEFAULT CHARSET = sjis engine = myisam;
	19	CREATE TABLE `sT` (`bP` char(20)) DEFAULT CHARSET = sjis engine = myisam;
	20	CREATE TABLE `sU` (`bP` char(20)) DEFAULT CHARSET = sjis engine = myisam;
	21	CREATE TABLE `sV` (`bP` char(20)) DEFAULT CHARSET = sjis engine = heap;
	22	CREATE TABLE `sW` (`bP` char(20)) DEFAULT CHARSET = sjis engine = heap;
	23	CREATE TABLE `sX` (`bP` char(20)) DEFAULT CHARSET = sjis engine = heap;
	24	CREATE TABLE `sPO` (`bP` char(20)) DEFAULT CHARSET = sjis engine = bdb;
	25	CREATE TABLE `sPP` (`bP` char(20)) DEFAULT CHARSET = sjis engine = bdb;
	26	CREATE TABLE `sPQ` (`bP` char(20)) DEFAULT CHARSET = sjis engine = bdb;
	27	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sP`;
	28	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sQ`;
	29	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sR`;
	30	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sS`;
	31	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sT`;
	32	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sU`;
	33	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sV`;
	34	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sW`;
	35	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sX`;
	36	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sPO`;
	37	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sPP`;
	38	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sPQ`;
	39	SELECT DISTINCT CHARSET(`bP`) FROM `sP`;
	40	CHARSET(`bP`)
	41	sjis
	42	SELECT DISTINCT CHARSET(`bP`) FROM `sQ`;
	43	CHARSET(`bP`)
	44	sjis
	45	SELECT DISTINCT CHARSET(`bP`) FROM `sR`;
	46	CHARSET(`bP`)
	47	sjis
	48	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sP`;
	49	CHARSET(CONVERT(`bP` USING utf8))
	50	utf8
	51	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sP`;
	52	CHARSET(CONVERT(`bP` USING ucs2))
	53	ucs2
	54	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sP`;
	55	CHARSET(CONVERT(`bP` USING sjis))
	56	sjis
	57	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sP`;
	58	CHARSET(CONVERT(`bP` USING ujis))
	59	ujis
	60	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sQ`;
	61	CHARSET(CONVERT(`bP` USING utf8))
	62	utf8
	63	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sQ`;
	64	CHARSET(CONVERT(`bP` USING ucs2))
65	ucs2
66	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sQ`;
67	CHARSET(CONVERT(`bP` USING sjis))
68	sjis
69	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sQ`;
70	CHARSET(CONVERT(`bP` USING ujis))
71	ujis
72	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sR`;
73	CHARSET(CONVERT(`bP` USING utf8))
74	utf8
75	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sR`;
76	CHARSET(CONVERT(`bP` USING ucs2))
77	ucs2
78	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sR`;
79	CHARSET(CONVERT(`bP` USING sjis))
80	sjis
81	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sR`;
82	CHARSET(CONVERT(`bP` USING ujis))
83	ujis
84	SELECT DISTINCT CHARSET(`bP`) FROM `sS`;
85	CHARSET(`bP`)
86	sjis
87	SELECT DISTINCT CHARSET(`bP`) FROM `sT`;
88	CHARSET(`bP`)
89	sjis
90	SELECT DISTINCT CHARSET(`bP`) FROM `sU`;
91	CHARSET(`bP`)
92	sjis
93	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sS`;
94	CHARSET(CONVERT(`bP` USING utf8))
95	utf8
96	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sS`;
97	CHARSET(CONVERT(`bP` USING ucs2))
98	ucs2
99	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sS`;
100	CHARSET(CONVERT(`bP` USING sjis))
101	sjis
102	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sS`;
103	CHARSET(CONVERT(`bP` USING ujis))
104	ujis
105	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sT`;
106	CHARSET(CONVERT(`bP` USING utf8))
107	utf8
108	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sT`;
109	CHARSET(CONVERT(`bP` USING ucs2))
110	ucs2
111	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sT`;
112	CHARSET(CONVERT(`bP` USING sjis))
113	sjis
114	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sT`;
115	CHARSET(CONVERT(`bP` USING ujis))
116	ujis
117	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sU`;
118	CHARSET(CONVERT(`bP` USING utf8))
119	utf8
120	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sU`;
121	CHARSET(CONVERT(`bP` USING ucs2))
122	ucs2
123	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sU`;
124	CHARSET(CONVERT(`bP` USING sjis))
125	sjis
126	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sU`;
127	CHARSET(CONVERT(`bP` USING ujis))
128	ujis
129	SELECT DISTINCT CHARSET(`bP`) FROM `sV`;
130	CHARSET(`bP`)
131	sjis
132	SELECT DISTINCT CHARSET(`bP`) FROM `sW`;
133	CHARSET(`bP`)
134	sjis
135	SELECT DISTINCT CHARSET(`bP`) FROM `sX`;
136	CHARSET(`bP`)
137	sjis
138	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sV`;
139	CHARSET(CONVERT(`bP` USING utf8))
140	utf8
141	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sV`;
142	CHARSET(CONVERT(`bP` USING ucs2))
143	ucs2
144	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sV`;
145	CHARSET(CONVERT(`bP` USING sjis))
146	sjis
147	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sV`;
148	CHARSET(CONVERT(`bP` USING ujis))
149	ujis
150	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sW`;
151	CHARSET(CONVERT(`bP` USING utf8))
152	utf8
153	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sW`;
154	CHARSET(CONVERT(`bP` USING ucs2))
155	ucs2
156	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sW`;
157	CHARSET(CONVERT(`bP` USING sjis))
158	sjis
159	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sW`;
160	CHARSET(CONVERT(`bP` USING ujis))
161	ujis
162	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sX`;
163	CHARSET(CONVERT(`bP` USING utf8))
164	utf8
165	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sX`;
166	CHARSET(CONVERT(`bP` USING ucs2))
167	ucs2
168	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sX`;
169	CHARSET(CONVERT(`bP` USING sjis))
170	sjis
171	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sX`;
172	CHARSET(CONVERT(`bP` USING ujis))
173	ujis
174	SELECT DISTINCT CHARSET(`bP`) FROM `sPO`;
175	CHARSET(`bP`)
176	sjis
177	SELECT DISTINCT CHARSET(`bP`) FROM `sPP`;
178	CHARSET(`bP`)
179	sjis
180	SELECT DISTINCT CHARSET(`bP`) FROM `sPQ`;
181	CHARSET(`bP`)
182	sjis
183	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sPO`;
184	CHARSET(CONVERT(`bP` USING utf8))
185	utf8
186	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sPO`;
187	CHARSET(CONVERT(`bP` USING ucs2))
188	ucs2
189	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sPO`;
190	CHARSET(CONVERT(`bP` USING sjis))
191	sjis
192	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sPO`;
193	CHARSET(CONVERT(`bP` USING ujis))
194	ujis
195	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sPP`;
196	CHARSET(CONVERT(`bP` USING utf8))
197	utf8
198	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sPP`;
199	CHARSET(CONVERT(`bP` USING ucs2))
200	ucs2
201	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sPP`;
202	CHARSET(CONVERT(`bP` USING sjis))
203	sjis
204	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sPP`;
205	CHARSET(CONVERT(`bP` USING ujis))
206	ujis
207	SELECT DISTINCT CHARSET(CONVERT(`bP` USING utf8)) FROM `sPQ`;
208	CHARSET(CONVERT(`bP` USING utf8))
209	utf8
210	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ucs2)) FROM `sPQ`;
211	CHARSET(CONVERT(`bP` USING ucs2))
212	ucs2
213	SELECT DISTINCT CHARSET(CONVERT(`bP` USING sjis)) FROM `sPQ`;
214	CHARSET(CONVERT(`bP` USING sjis))
215	sjis
216	SELECT DISTINCT CHARSET(CONVERT(`bP` USING ujis)) FROM `sPQ`;
217	CHARSET(CONVERT(`bP` USING ujis))
218	ujis
219	drop table `sP`;
220	drop table `sQ`;
221	drop table `sR`;
222	drop table `sS`;
223	drop table `sT`;
224	drop table `sU`;
225	drop table `sV`;
226	drop table `sW`;
227	drop table `sX`;
228	drop table `sPO`;
229	drop table `sPP`;
230	drop table `sPQ`;