1
drop table if exists t1;
3
create table t1 (c text character set ujis);
4
insert into t1 values (0xa4a2),(0xa4a3);
5
select hex(left(c,1)) from t1 group by c;
10
select locate(0xa2a1,0xa1a2a1a3);
11
locate(0xa2a1,0xa1a2a1a3)
13
select locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3);
14
locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3)
16
select locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3 collate ujis_bin);
17
locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3 collate ujis_bin)
19
select locate('he','hello');
22
select locate('he','hello',2);
23
locate('he','hello',2)
25
select locate('lo','hello',2);
26
locate('lo','hello',2)
28
select locate('HE','hello');
31
select locate('HE','hello',2);
32
locate('HE','hello',2)
34
select locate('LO','hello',2);
35
locate('LO','hello',2)
37
select locate('HE','hello' collate ujis_bin);
38
locate('HE','hello' collate ujis_bin)
40
select locate('HE','hello' collate ujis_bin,2);
41
locate('HE','hello' collate ujis_bin,2)
43
select locate('LO','hello' collate ujis_bin,2);
44
locate('LO','hello' collate ujis_bin,2)
46
select locate(_ujis 0xa1a3,_ujis 0xa1a2a1a3);
47
locate(_ujis 0xa1a3,_ujis 0xa1a2a1a3)
49
select 0xa1a2a1a3 like concat(_binary'%',0xa2a1,_binary'%');
50
0xa1a2a1a3 like concat(_binary'%',0xa2a1,_binary'%')
52
select _ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%');
53
_ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%')
55
select _ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%') collate ujis_bin;
56
_ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%') collate ujis_bin
64
select 'A' like 'a' collate ujis_bin;
65
'A' like 'a' collate ujis_bin
67
set @ujis1= _ujis 0x8EA18EA28EA38EA48EA58EA68EA78EA88EA98EAA8EAB8EAC8EAD8EAE8EAF;
68
set @ujis2= _ujis 0x8EB08EB18EB28EB38EB48EB58EB68EB78EB88EB98EBA8EBB8EBC8EBD8EBE8EBF;
69
set @ujis3= _ujis 0x8EC08EC18EC28EC38EC48EC58EC68EC78EC88EC98ECA8ECB8ECC8ECD8ECE8ECF;
70
set @ujis4= _ujis 0x8ED08ED18ED28ED38ED48ED58ED68ED78ED88ED98EDA8EDB8EDC8EDD8EDE8EDF;
71
select hex(@utf81:= CONVERT(@ujis1 USING utf8));
72
hex(@utf81:= CONVERT(@ujis1 USING utf8))
73
EFBDA1EFBDA2EFBDA3EFBDA4EFBDA5EFBDA6EFBDA7EFBDA8EFBDA9EFBDAAEFBDABEFBDACEFBDADEFBDAEEFBDAF
74
select hex(@utf82:= CONVERT(@ujis2 USING utf8));
75
hex(@utf82:= CONVERT(@ujis2 USING utf8))
76
EFBDB0EFBDB1EFBDB2EFBDB3EFBDB4EFBDB5EFBDB6EFBDB7EFBDB8EFBDB9EFBDBAEFBDBBEFBDBCEFBDBDEFBDBEEFBDBF
77
select hex(@utf83:= CONVERT(@ujis3 USING utf8));
78
hex(@utf83:= CONVERT(@ujis3 USING utf8))
79
EFBE80EFBE81EFBE82EFBE83EFBE84EFBE85EFBE86EFBE87EFBE88EFBE89EFBE8AEFBE8BEFBE8CEFBE8DEFBE8EEFBE8F
80
select hex(@utf84:= CONVERT(@ujis4 USING utf8));
81
hex(@utf84:= CONVERT(@ujis4 USING utf8))
82
EFBE90EFBE91EFBE92EFBE93EFBE94EFBE95EFBE96EFBE97EFBE98EFBE99EFBE9AEFBE9BEFBE9CEFBE9DEFBE9EEFBE9F
83
select @ujis1 = CONVERT(@utf81 USING ujis);
84
@ujis1 = CONVERT(@utf81 USING ujis)
86
select @ujis2 = CONVERT(@utf82 USING ujis);
87
@ujis2 = CONVERT(@utf82 USING ujis)
89
select @ujis3 = CONVERT(@utf83 USING ujis);
90
@ujis3 = CONVERT(@utf83 USING ujis)
92
select @ujis4 = CONVERT(@utf84 USING ujis);
93
@ujis4 = CONVERT(@utf84 USING ujis)
95
drop table if exists t1;
97
Note 1051 Unknown table 't1'
98
create table t1 (c1 varchar(8)) default character set 'ujis';
99
insert into t1 values (0xA4A2),(0xA2A2),(0xA4A2);
100
select c1 as 'no index' from t1 where c1 like cast(concat(0xA4A2, '%') as char character set ujis);
104
create index idx_c1 on t1(c1);
105
select c1 as 'using index' from t1 where c1 like cast(concat(0xA4A2, '%') as char character set ujis);
109
select c1 as 'no index' from t1 where c1 like cast(concat('%',0xA4A2, '%') as char character set ujis);
115
a char(1) NOT NULL default '',
116
b enum('��','��') default NULL
117
) CHARACTER SET ujis;
118
SHOW CREATE TABLE t1;
120
t1 CREATE TABLE `t1` (
121
`a` char(1) NOT NULL DEFAULT '',
122
`b` enum('��','��') DEFAULT NULL
123
) ENGINE=MyISAM DEFAULT CHARSET=ujis
124
SHOW COLUMNS FROM t1;
125
Field Type Null Key Default Extra
127
b enum('��','��') YES NULL
132
b VARCHAR(50) NOT NULL DEFAULT '',
135
) ENGINE=InnoDB CHARACTER SET 'ujis' COLLATE 'ujis_japanese_ci';
136
INSERT INTO t1 (a, b) VALUES (0, 'aaabbbcccddd');
137
INSERT INTO t1 (a, b) VALUES (1, 'eeefffggghhh');
138
INSERT INTO t1 (a, b) VALUES (2, 'iiijjjkkkl');
139
SELECT t1.* FROM t1 WHERE b='aaabbbcccddd' ORDER BY a;
142
SELECT t1.* FROM t1 WHERE b='eeefffggghhh' ORDER BY a;
145
SELECT t1.* FROM t1 WHERE b='iiijjjkkkl' ORDER BY a;
152
b VARCHAR(50) NOT NULL DEFAULT '',
155
) ENGINE=MyISAM CHARACTER SET 'ujis' COLLATE 'ujis_japanese_ci';
156
INSERT INTO t1 (a, b) VALUES (0, 'aaabbbcccddd');
157
INSERT INTO t1 (a, b) VALUES (1, 'eeefffggghhh');
158
INSERT INTO t1 (a, b) VALUES (2, 'iiijjjkkkl');
159
SELECT t1.* FROM t1 WHERE b='aaabbbcccddd' ORDER BY a;
162
SELECT t1.* FROM t1 WHERE b='eeefffggghhh' ORDER BY a;
165
SELECT t1.* FROM t1 WHERE b='iiijjjkkkl' ORDER BY a;
169
DROP TABLE IF EXISTS t1;
171
Note 1051 Unknown table 't1'
172
CREATE TABLE t1(c char(1)) character set ujis;
173
INSERT INTO t1 VALUES(0xA2AF);
174
INSERT INTO t1 VALUES(0xA2B0);
175
INSERT INTO t1 VALUES(0xA2B1);
176
INSERT INTO t1 VALUES(0xA2B2);
177
INSERT INTO t1 VALUES(0xA2B3);
178
INSERT INTO t1 VALUES(0xA2B4);
179
INSERT INTO t1 VALUES(0xA2B5);
180
INSERT INTO t1 VALUES(0xA2B6);
181
INSERT INTO t1 VALUES(0xA2B7);
182
INSERT INTO t1 VALUES(0xA2B8);
183
INSERT INTO t1 VALUES(0xA2B9);
184
INSERT INTO t1 VALUES(0xA2C2);
185
INSERT INTO t1 VALUES(0xA2C3);
186
INSERT INTO t1 VALUES(0xA2C4);
187
INSERT INTO t1 VALUES(0xA2C5);
188
INSERT INTO t1 VALUES(0xA2C6);
189
INSERT INTO t1 VALUES(0xA2C7);
190
INSERT INTO t1 VALUES(0xA2C8);
191
INSERT INTO t1 VALUES(0xA2C9);
192
INSERT INTO t1 VALUES(0xA2D1);
193
INSERT INTO t1 VALUES(0xA2D2);
194
INSERT INTO t1 VALUES(0xA2D3);
195
INSERT INTO t1 VALUES(0xA2D4);
196
INSERT INTO t1 VALUES(0xA2D5);
197
INSERT INTO t1 VALUES(0xA2D6);
198
INSERT INTO t1 VALUES(0xA2D7);
199
INSERT INTO t1 VALUES(0xA2D8);
200
INSERT INTO t1 VALUES(0xA2D9);
201
INSERT INTO t1 VALUES(0xA2DA);
202
INSERT INTO t1 VALUES(0xA2DB);
203
INSERT INTO t1 VALUES(0xA2EB);
204
INSERT INTO t1 VALUES(0xA2EC);
205
INSERT INTO t1 VALUES(0xA2ED);
206
INSERT INTO t1 VALUES(0xA2EE);
207
INSERT INTO t1 VALUES(0xA2EF);
208
INSERT INTO t1 VALUES(0xA2F0);
209
INSERT INTO t1 VALUES(0xA2F1);
210
INSERT INTO t1 VALUES(0xA2FA);
211
INSERT INTO t1 VALUES(0xA2FB);
212
INSERT INTO t1 VALUES(0xA2FC);
213
INSERT INTO t1 VALUES(0xA2FD);
214
INSERT INTO t1 VALUES(0xA3A1);
215
INSERT INTO t1 VALUES(0xA3A2);
216
INSERT INTO t1 VALUES(0xA3A3);
217
INSERT INTO t1 VALUES(0xA3A4);
218
INSERT INTO t1 VALUES(0xA3A5);
219
INSERT INTO t1 VALUES(0xA3A6);
220
INSERT INTO t1 VALUES(0xA3A7);
221
INSERT INTO t1 VALUES(0xA3A8);
222
INSERT INTO t1 VALUES(0xA3A9);
223
INSERT INTO t1 VALUES(0xA3AA);
224
INSERT INTO t1 VALUES(0xA3AB);
225
INSERT INTO t1 VALUES(0xA3AC);
226
INSERT INTO t1 VALUES(0xA3AD);
227
INSERT INTO t1 VALUES(0xA3AE);
228
INSERT INTO t1 VALUES(0xA3AF);
229
INSERT INTO t1 VALUES(0xA3BA);
230
INSERT INTO t1 VALUES(0xA3BB);
231
INSERT INTO t1 VALUES(0xA3BC);
232
INSERT INTO t1 VALUES(0xA3BD);
233
INSERT INTO t1 VALUES(0xA3BE);
234
INSERT INTO t1 VALUES(0xA3BF);
235
INSERT INTO t1 VALUES(0xA3C0);
236
INSERT INTO t1 VALUES(0xA3DB);
237
INSERT INTO t1 VALUES(0xA3DC);
238
INSERT INTO t1 VALUES(0xA3DD);
239
INSERT INTO t1 VALUES(0xA3DE);
240
INSERT INTO t1 VALUES(0xA3DF);
241
INSERT INTO t1 VALUES(0xA3E0);
242
INSERT INTO t1 VALUES(0xA3FB);
243
INSERT INTO t1 VALUES(0xA3FC);
244
INSERT INTO t1 VALUES(0xA3FD);
245
INSERT INTO t1 VALUES(0xA3FE);
246
INSERT INTO t1 VALUES(0xA4F4);
247
INSERT INTO t1 VALUES(0xA4F5);
248
INSERT INTO t1 VALUES(0xA4F6);
249
INSERT INTO t1 VALUES(0xA4F7);
250
INSERT INTO t1 VALUES(0xA4F8);
251
INSERT INTO t1 VALUES(0xA4F9);
252
INSERT INTO t1 VALUES(0xA4FA);
253
INSERT INTO t1 VALUES(0xA4FB);
254
INSERT INTO t1 VALUES(0xA4FC);
255
INSERT INTO t1 VALUES(0xA4FD);
256
INSERT INTO t1 VALUES(0xA4FE);
257
INSERT INTO t1 VALUES(0xA5F7);
258
INSERT INTO t1 VALUES(0xA5F8);
259
INSERT INTO t1 VALUES(0xA5F9);
260
INSERT INTO t1 VALUES(0xA5FA);
261
INSERT INTO t1 VALUES(0xA5FB);
262
INSERT INTO t1 VALUES(0xA5FC);
263
INSERT INTO t1 VALUES(0xA5FD);
264
INSERT INTO t1 VALUES(0xA5FE);
265
INSERT INTO t1 VALUES(0xA6B9);
266
INSERT INTO t1 VALUES(0xA6BA);
267
INSERT INTO t1 VALUES(0xA6BB);
268
INSERT INTO t1 VALUES(0xA6BC);
269
INSERT INTO t1 VALUES(0xA6BD);
270
INSERT INTO t1 VALUES(0xA6BE);
271
INSERT INTO t1 VALUES(0xA6BF);
272
INSERT INTO t1 VALUES(0xA6C0);
273
INSERT INTO t1 VALUES(0xA6D9);
274
INSERT INTO t1 VALUES(0xA6DA);
275
INSERT INTO t1 VALUES(0xA6DB);
276
INSERT INTO t1 VALUES(0xA6DC);
277
INSERT INTO t1 VALUES(0xA6DD);
278
INSERT INTO t1 VALUES(0xA6DE);
279
INSERT INTO t1 VALUES(0xA6DF);
280
INSERT INTO t1 VALUES(0xA6E0);
281
INSERT INTO t1 VALUES(0xA6E1);
282
INSERT INTO t1 VALUES(0xA6E2);
283
INSERT INTO t1 VALUES(0xA6E3);
284
INSERT INTO t1 VALUES(0xA6E4);
285
INSERT INTO t1 VALUES(0xA6E5);
286
INSERT INTO t1 VALUES(0xA6E6);
287
INSERT INTO t1 VALUES(0xA6E7);
288
INSERT INTO t1 VALUES(0xA6E8);
289
INSERT INTO t1 VALUES(0xA6E9);
290
INSERT INTO t1 VALUES(0xA6EA);
291
INSERT INTO t1 VALUES(0xA6EB);
292
INSERT INTO t1 VALUES(0xA6EC);
293
INSERT INTO t1 VALUES(0xA6ED);
294
INSERT INTO t1 VALUES(0xA6EE);
295
INSERT INTO t1 VALUES(0xA6EF);
296
INSERT INTO t1 VALUES(0xA6F0);
297
INSERT INTO t1 VALUES(0xA6F1);
298
INSERT INTO t1 VALUES(0xA6F2);
299
INSERT INTO t1 VALUES(0xA6F3);
300
INSERT INTO t1 VALUES(0xA6F4);
301
INSERT INTO t1 VALUES(0xA6F5);
302
INSERT INTO t1 VALUES(0xA6F6);
303
INSERT INTO t1 VALUES(0xA6F7);
304
INSERT INTO t1 VALUES(0xA6F8);
305
INSERT INTO t1 VALUES(0xA6F9);
306
INSERT INTO t1 VALUES(0xA6FA);
307
INSERT INTO t1 VALUES(0xA6FB);
308
INSERT INTO t1 VALUES(0xA6FC);
309
INSERT INTO t1 VALUES(0xA6FD);
310
INSERT INTO t1 VALUES(0xA6FE);
311
INSERT INTO t1 VALUES(0xA7C2);
312
INSERT INTO t1 VALUES(0xA7C3);
313
INSERT INTO t1 VALUES(0xA7C4);
314
INSERT INTO t1 VALUES(0xA7C5);
315
INSERT INTO t1 VALUES(0xA7C6);
316
INSERT INTO t1 VALUES(0xA7C7);
317
INSERT INTO t1 VALUES(0xA7C8);
318
INSERT INTO t1 VALUES(0xA7C9);
319
INSERT INTO t1 VALUES(0xA7CA);
320
INSERT INTO t1 VALUES(0xA7CB);
321
INSERT INTO t1 VALUES(0xA7CC);
322
INSERT INTO t1 VALUES(0xA7CD);
323
INSERT INTO t1 VALUES(0xA7CE);
324
INSERT INTO t1 VALUES(0xA7CF);
325
INSERT INTO t1 VALUES(0xA7D0);
326
INSERT INTO t1 VALUES(0xA7F2);
327
INSERT INTO t1 VALUES(0xA7F3);
328
INSERT INTO t1 VALUES(0xA7F4);
329
INSERT INTO t1 VALUES(0xA7F5);
330
INSERT INTO t1 VALUES(0xA7F6);
331
INSERT INTO t1 VALUES(0xA7F7);
332
INSERT INTO t1 VALUES(0xA7F8);
333
INSERT INTO t1 VALUES(0xA7F9);
334
INSERT INTO t1 VALUES(0xA7FA);
335
INSERT INTO t1 VALUES(0xA7FB);
336
INSERT INTO t1 VALUES(0xA7FC);
337
INSERT INTO t1 VALUES(0xA7FD);
338
INSERT INTO t1 VALUES(0xA7FE);
339
INSERT INTO t1 VALUES(0xA8C1);
340
INSERT INTO t1 VALUES(0xA8C2);
341
INSERT INTO t1 VALUES(0xA8C3);
342
INSERT INTO t1 VALUES(0xA8C4);
343
INSERT INTO t1 VALUES(0xA8C5);
344
INSERT INTO t1 VALUES(0xA8C6);
345
INSERT INTO t1 VALUES(0xA8C7);
346
INSERT INTO t1 VALUES(0xA8C8);
347
INSERT INTO t1 VALUES(0xA8C9);
348
INSERT INTO t1 VALUES(0xA8CA);
349
INSERT INTO t1 VALUES(0xA8CB);
350
INSERT INTO t1 VALUES(0xA8CC);
351
INSERT INTO t1 VALUES(0xA8CD);
352
INSERT INTO t1 VALUES(0xA8CE);
353
INSERT INTO t1 VALUES(0xA8CF);
354
INSERT INTO t1 VALUES(0xA8D0);
355
INSERT INTO t1 VALUES(0xA8D1);
356
INSERT INTO t1 VALUES(0xA8D2);
357
INSERT INTO t1 VALUES(0xA8D3);
358
INSERT INTO t1 VALUES(0xA8D4);
359
INSERT INTO t1 VALUES(0xA8D5);
360
INSERT INTO t1 VALUES(0xA8D6);
361
INSERT INTO t1 VALUES(0xA8D7);
362
INSERT INTO t1 VALUES(0xA8D8);
363
INSERT INTO t1 VALUES(0xA8D9);
364
INSERT INTO t1 VALUES(0xA8DA);
365
INSERT INTO t1 VALUES(0xA8DB);
366
INSERT INTO t1 VALUES(0xA8DC);
367
INSERT INTO t1 VALUES(0xA8DD);
368
INSERT INTO t1 VALUES(0xA8DE);
369
INSERT INTO t1 VALUES(0xA8DF);
370
INSERT INTO t1 VALUES(0xA8E0);
371
INSERT INTO t1 VALUES(0xA8E1);
372
INSERT INTO t1 VALUES(0xA8E2);
373
INSERT INTO t1 VALUES(0xA8E3);
374
INSERT INTO t1 VALUES(0xA8E4);
375
INSERT INTO t1 VALUES(0xA8E5);
376
INSERT INTO t1 VALUES(0xA8E6);
377
INSERT INTO t1 VALUES(0xA8E7);
378
INSERT INTO t1 VALUES(0xA8E8);
379
INSERT INTO t1 VALUES(0xA8E9);
380
INSERT INTO t1 VALUES(0xA8EA);
381
INSERT INTO t1 VALUES(0xA8EB);
382
INSERT INTO t1 VALUES(0xA8EC);
383
INSERT INTO t1 VALUES(0xA8ED);
384
INSERT INTO t1 VALUES(0xA8EE);
385
INSERT INTO t1 VALUES(0xA8EF);
386
INSERT INTO t1 VALUES(0xA8F0);
387
INSERT INTO t1 VALUES(0xA8F1);
388
INSERT INTO t1 VALUES(0xA8F2);
389
INSERT INTO t1 VALUES(0xA8F3);
390
INSERT INTO t1 VALUES(0xA8F4);
391
INSERT INTO t1 VALUES(0xA8F5);
392
INSERT INTO t1 VALUES(0xA8F6);
393
INSERT INTO t1 VALUES(0xA8F7);
394
INSERT INTO t1 VALUES(0xA8F8);
395
INSERT INTO t1 VALUES(0xA8F9);
396
INSERT INTO t1 VALUES(0xA8FA);
397
INSERT INTO t1 VALUES(0xA8FB);
398
INSERT INTO t1 VALUES(0xA8FC);
399
INSERT INTO t1 VALUES(0xA8FD);
400
INSERT INTO t1 VALUES(0xA8FE);
401
INSERT INTO t1 VALUES(0xA9A1);
402
INSERT INTO t1 VALUES(0xA9A2);
403
INSERT INTO t1 VALUES(0xA9A3);
404
INSERT INTO t1 VALUES(0xA9A4);
405
INSERT INTO t1 VALUES(0xA9A5);
406
INSERT INTO t1 VALUES(0xA9A6);
407
INSERT INTO t1 VALUES(0xA9A7);
408
INSERT INTO t1 VALUES(0xA9A8);
409
INSERT INTO t1 VALUES(0xA9A9);
410
INSERT INTO t1 VALUES(0xA9AA);
411
INSERT INTO t1 VALUES(0xA9AB);
412
INSERT INTO t1 VALUES(0xA9AC);
413
INSERT INTO t1 VALUES(0xA9AD);
414
INSERT INTO t1 VALUES(0xA9AE);
415
INSERT INTO t1 VALUES(0xA9AF);
416
INSERT INTO t1 VALUES(0xA9B0);
417
INSERT INTO t1 VALUES(0xA9B1);
418
INSERT INTO t1 VALUES(0xA9B2);
419
INSERT INTO t1 VALUES(0xA9B3);
420
INSERT INTO t1 VALUES(0xA9B4);
421
INSERT INTO t1 VALUES(0xA9B5);
422
INSERT INTO t1 VALUES(0xA9B6);
423
INSERT INTO t1 VALUES(0xA9B7);
424
INSERT INTO t1 VALUES(0xA9B8);
425
INSERT INTO t1 VALUES(0xA9B9);
426
INSERT INTO t1 VALUES(0xA9BA);
427
INSERT INTO t1 VALUES(0xA9BB);
428
INSERT INTO t1 VALUES(0xA9BC);
429
INSERT INTO t1 VALUES(0xA9BD);
430
INSERT INTO t1 VALUES(0xA9BE);
431
INSERT INTO t1 VALUES(0xA9BF);
432
INSERT INTO t1 VALUES(0xA9C0);
433
INSERT INTO t1 VALUES(0xA9C1);
434
INSERT INTO t1 VALUES(0xA9C2);
435
INSERT INTO t1 VALUES(0xA9C3);
436
INSERT INTO t1 VALUES(0xA9C4);
437
INSERT INTO t1 VALUES(0xA9C5);
438
INSERT INTO t1 VALUES(0xA9C6);
439
INSERT INTO t1 VALUES(0xA9C7);
440
INSERT INTO t1 VALUES(0xA9C8);
441
INSERT INTO t1 VALUES(0xA9C9);
442
INSERT INTO t1 VALUES(0xA9CA);
443
INSERT INTO t1 VALUES(0xA9CB);
444
INSERT INTO t1 VALUES(0xA9CC);
445
INSERT INTO t1 VALUES(0xA9CD);
446
INSERT INTO t1 VALUES(0xA9CE);
447
INSERT INTO t1 VALUES(0xA9CF);
448
INSERT INTO t1 VALUES(0xA9D0);
449
INSERT INTO t1 VALUES(0xA9D1);
450
INSERT INTO t1 VALUES(0xA9D2);
451
INSERT INTO t1 VALUES(0xA9D3);
452
INSERT INTO t1 VALUES(0xA9D4);
453
INSERT INTO t1 VALUES(0xA9D5);
454
INSERT INTO t1 VALUES(0xA9D6);
455
INSERT INTO t1 VALUES(0xA9D7);
456
INSERT INTO t1 VALUES(0xA9D8);
457
INSERT INTO t1 VALUES(0xA9D9);
458
INSERT INTO t1 VALUES(0xA9DA);
459
INSERT INTO t1 VALUES(0xA9DB);
460
INSERT INTO t1 VALUES(0xA9DC);
461
INSERT INTO t1 VALUES(0xA9DD);
462
INSERT INTO t1 VALUES(0xA9DE);
463
INSERT INTO t1 VALUES(0xA9DF);
464
INSERT INTO t1 VALUES(0xA9E0);
465
INSERT INTO t1 VALUES(0xA9E1);
466
INSERT INTO t1 VALUES(0xA9E2);
467
INSERT INTO t1 VALUES(0xA9E3);
468
INSERT INTO t1 VALUES(0xA9E4);
469
INSERT INTO t1 VALUES(0xA9E5);
470
INSERT INTO t1 VALUES(0xA9E6);
471
INSERT INTO t1 VALUES(0xA9E7);
472
INSERT INTO t1 VALUES(0xA9E8);
473
INSERT INTO t1 VALUES(0xA9E9);
474
INSERT INTO t1 VALUES(0xA9EA);
475
INSERT INTO t1 VALUES(0xA9EB);
476
INSERT INTO t1 VALUES(0xA9EC);
477
INSERT INTO t1 VALUES(0xA9ED);
478
INSERT INTO t1 VALUES(0xA9EE);
479
INSERT INTO t1 VALUES(0xA9EF);
480
INSERT INTO t1 VALUES(0xA9F0);
481
INSERT INTO t1 VALUES(0xA9F1);
482
INSERT INTO t1 VALUES(0xA9F2);
483
INSERT INTO t1 VALUES(0xA9F3);
484
INSERT INTO t1 VALUES(0xA9F4);
485
INSERT INTO t1 VALUES(0xA9F5);
486
INSERT INTO t1 VALUES(0xA9F6);
487
INSERT INTO t1 VALUES(0xA9F7);
488
INSERT INTO t1 VALUES(0xA9F8);
489
INSERT INTO t1 VALUES(0xA9F9);
490
INSERT INTO t1 VALUES(0xA9FA);
491
INSERT INTO t1 VALUES(0xA9FB);
492
INSERT INTO t1 VALUES(0xA9FC);
493
INSERT INTO t1 VALUES(0xA9FD);
494
INSERT INTO t1 VALUES(0xA9FE);
495
INSERT INTO t1 VALUES(0xAAA1);
496
INSERT INTO t1 VALUES(0xAAA2);
497
INSERT INTO t1 VALUES(0xAAA3);
498
INSERT INTO t1 VALUES(0xAAA4);
499
INSERT INTO t1 VALUES(0xAAA5);
500
INSERT INTO t1 VALUES(0xAAA6);
501
INSERT INTO t1 VALUES(0xAAA7);
502
INSERT INTO t1 VALUES(0xAAA8);
503
INSERT INTO t1 VALUES(0xAAA9);
504
INSERT INTO t1 VALUES(0xAAAA);
505
INSERT INTO t1 VALUES(0xAAAB);
506
INSERT INTO t1 VALUES(0xAAAC);
507
INSERT INTO t1 VALUES(0xAAAD);
508
INSERT INTO t1 VALUES(0xAAAE);
509
INSERT INTO t1 VALUES(0xAAAF);
510
INSERT INTO t1 VALUES(0xAAB0);
511
INSERT INTO t1 VALUES(0xAAB1);
512
INSERT INTO t1 VALUES(0xAAB2);
513
INSERT INTO t1 VALUES(0xAAB3);
514
INSERT INTO t1 VALUES(0xAAB4);
515
INSERT INTO t1 VALUES(0xAAB5);
516
INSERT INTO t1 VALUES(0xAAB6);
517
INSERT INTO t1 VALUES(0xAAB7);
518
INSERT INTO t1 VALUES(0xAAB8);
519
INSERT INTO t1 VALUES(0xAAB9);
520
INSERT INTO t1 VALUES(0xAABA);
521
INSERT INTO t1 VALUES(0xAABB);
522
INSERT INTO t1 VALUES(0xAABC);
523
INSERT INTO t1 VALUES(0xAABD);
524
INSERT INTO t1 VALUES(0xAABE);
525
INSERT INTO t1 VALUES(0xAABF);
526
INSERT INTO t1 VALUES(0xAAC0);
527
INSERT INTO t1 VALUES(0xAAC1);
528
INSERT INTO t1 VALUES(0xAAC2);
529
INSERT INTO t1 VALUES(0xAAC3);
530
INSERT INTO t1 VALUES(0xAAC4);
531
INSERT INTO t1 VALUES(0xAAC5);
532
INSERT INTO t1 VALUES(0xAAC6);
533
INSERT INTO t1 VALUES(0xAAC7);
534
INSERT INTO t1 VALUES(0xAAC8);
535
INSERT INTO t1 VALUES(0xAAC9);
536
INSERT INTO t1 VALUES(0xAACA);
537
INSERT INTO t1 VALUES(0xAACB);
538
INSERT INTO t1 VALUES(0xAACC);
539
INSERT INTO t1 VALUES(0xAACD);
540
INSERT INTO t1 VALUES(0xAACE);
541
INSERT INTO t1 VALUES(0xAACF);
542
INSERT INTO t1 VALUES(0xAAD0);
543
INSERT INTO t1 VALUES(0xAAD1);
544
INSERT INTO t1 VALUES(0xAAD2);
545
INSERT INTO t1 VALUES(0xAAD3);
546
INSERT INTO t1 VALUES(0xAAD4);
547
INSERT INTO t1 VALUES(0xAAD5);
548
INSERT INTO t1 VALUES(0xAAD6);
549
INSERT INTO t1 VALUES(0xAAD7);
550
INSERT INTO t1 VALUES(0xAAD8);
551
INSERT INTO t1 VALUES(0xAAD9);
552
INSERT INTO t1 VALUES(0xAADA);
553
INSERT INTO t1 VALUES(0xAADB);
554
INSERT INTO t1 VALUES(0xAADC);
555
INSERT INTO t1 VALUES(0xAADD);
556
INSERT INTO t1 VALUES(0xAADE);
557
INSERT INTO t1 VALUES(0xAADF);
558
INSERT INTO t1 VALUES(0xAAE0);
559
INSERT INTO t1 VALUES(0xAAE1);
560
INSERT INTO t1 VALUES(0xAAE2);
561
INSERT INTO t1 VALUES(0xAAE3);
562
INSERT INTO t1 VALUES(0xAAE4);
563
INSERT INTO t1 VALUES(0xAAE5);
564
INSERT INTO t1 VALUES(0xAAE6);
565
INSERT INTO t1 VALUES(0xAAE7);
566
INSERT INTO t1 VALUES(0xAAE8);
567
INSERT INTO t1 VALUES(0xAAE9);
568
INSERT INTO t1 VALUES(0xAAEA);
569
INSERT INTO t1 VALUES(0xAAEB);
570
INSERT INTO t1 VALUES(0xAAEC);
571
INSERT INTO t1 VALUES(0xAAED);
572
INSERT INTO t1 VALUES(0xAAEE);
573
INSERT INTO t1 VALUES(0xAAEF);
574
INSERT INTO t1 VALUES(0xAAF0);
575
INSERT INTO t1 VALUES(0xAAF1);
576
INSERT INTO t1 VALUES(0xAAF2);
577
INSERT INTO t1 VALUES(0xAAF3);
578
INSERT INTO t1 VALUES(0xAAF4);
579
INSERT INTO t1 VALUES(0xAAF5);
580
INSERT INTO t1 VALUES(0xAAF6);
581
INSERT INTO t1 VALUES(0xAAF7);
582
INSERT INTO t1 VALUES(0xAAF8);
583
INSERT INTO t1 VALUES(0xAAF9);
584
INSERT INTO t1 VALUES(0xAAFA);
585
INSERT INTO t1 VALUES(0xAAFB);
586
INSERT INTO t1 VALUES(0xAAFC);
587
INSERT INTO t1 VALUES(0xAAFD);
588
INSERT INTO t1 VALUES(0xAAFE);
589
INSERT INTO t1 VALUES(0xABA1);
590
INSERT INTO t1 VALUES(0xABA2);
591
INSERT INTO t1 VALUES(0xABA3);
592
INSERT INTO t1 VALUES(0xABA4);
593
INSERT INTO t1 VALUES(0xABA5);
594
INSERT INTO t1 VALUES(0xABA6);
595
INSERT INTO t1 VALUES(0xABA7);
596
INSERT INTO t1 VALUES(0xABA8);
597
INSERT INTO t1 VALUES(0xABA9);
598
INSERT INTO t1 VALUES(0xABAA);
599
INSERT INTO t1 VALUES(0xABAB);
600
INSERT INTO t1 VALUES(0xABAC);
601
INSERT INTO t1 VALUES(0xABAD);
602
INSERT INTO t1 VALUES(0xABAE);
603
INSERT INTO t1 VALUES(0xABAF);
604
INSERT INTO t1 VALUES(0xABB0);
605
INSERT INTO t1 VALUES(0xABB1);
606
INSERT INTO t1 VALUES(0xABB2);
607
INSERT INTO t1 VALUES(0xABB3);
608
INSERT INTO t1 VALUES(0xABB4);
609
INSERT INTO t1 VALUES(0xABB5);
610
INSERT INTO t1 VALUES(0xABB6);
611
INSERT INTO t1 VALUES(0xABB7);
612
INSERT INTO t1 VALUES(0xABB8);
613
INSERT INTO t1 VALUES(0xABB9);
614
INSERT INTO t1 VALUES(0xABBA);
615
INSERT INTO t1 VALUES(0xABBB);
616
INSERT INTO t1 VALUES(0xABBC);
617
INSERT INTO t1 VALUES(0xABBD);
618
INSERT INTO t1 VALUES(0xABBE);
619
INSERT INTO t1 VALUES(0xABBF);
620
INSERT INTO t1 VALUES(0xABC0);
621
INSERT INTO t1 VALUES(0xABC1);
622
INSERT INTO t1 VALUES(0xABC2);
623
INSERT INTO t1 VALUES(0xABC3);
624
INSERT INTO t1 VALUES(0xABC4);
625
INSERT INTO t1 VALUES(0xABC5);
626
INSERT INTO t1 VALUES(0xABC6);
627
INSERT INTO t1 VALUES(0xABC7);
628
INSERT INTO t1 VALUES(0xABC8);
629
INSERT INTO t1 VALUES(0xABC9);
630
INSERT INTO t1 VALUES(0xABCA);
631
INSERT INTO t1 VALUES(0xABCB);
632
INSERT INTO t1 VALUES(0xABCC);
633
INSERT INTO t1 VALUES(0xABCD);
634
INSERT INTO t1 VALUES(0xABCE);
635
INSERT INTO t1 VALUES(0xABCF);
636
INSERT INTO t1 VALUES(0xABD0);
637
INSERT INTO t1 VALUES(0xABD1);
638
INSERT INTO t1 VALUES(0xABD2);
639
INSERT INTO t1 VALUES(0xABD3);
640
INSERT INTO t1 VALUES(0xABD4);
641
INSERT INTO t1 VALUES(0xABD5);
642
INSERT INTO t1 VALUES(0xABD6);
643
INSERT INTO t1 VALUES(0xABD7);
644
INSERT INTO t1 VALUES(0xABD8);
645
INSERT INTO t1 VALUES(0xABD9);
646
INSERT INTO t1 VALUES(0xABDA);
647
INSERT INTO t1 VALUES(0xABDB);
648
INSERT INTO t1 VALUES(0xABDC);
649
INSERT INTO t1 VALUES(0xABDD);
650
INSERT INTO t1 VALUES(0xABDE);
651
INSERT INTO t1 VALUES(0xABDF);
652
INSERT INTO t1 VALUES(0xABE0);
653
INSERT INTO t1 VALUES(0xABE1);
654
INSERT INTO t1 VALUES(0xABE2);
655
INSERT INTO t1 VALUES(0xABE3);
656
INSERT INTO t1 VALUES(0xABE4);
657
INSERT INTO t1 VALUES(0xABE5);
658
INSERT INTO t1 VALUES(0xABE6);
659
INSERT INTO t1 VALUES(0xABE7);
660
INSERT INTO t1 VALUES(0xABE8);
661
INSERT INTO t1 VALUES(0xABE9);
662
INSERT INTO t1 VALUES(0xABEA);
663
INSERT INTO t1 VALUES(0xABEB);
664
INSERT INTO t1 VALUES(0xABEC);
665
INSERT INTO t1 VALUES(0xABED);
666
INSERT INTO t1 VALUES(0xABEE);
667
INSERT INTO t1 VALUES(0xABEF);
668
INSERT INTO t1 VALUES(0xABF0);
669
INSERT INTO t1 VALUES(0xABF1);
670
INSERT INTO t1 VALUES(0xABF2);
671
INSERT INTO t1 VALUES(0xABF3);
672
INSERT INTO t1 VALUES(0xABF4);
673
INSERT INTO t1 VALUES(0xABF5);
674
INSERT INTO t1 VALUES(0xABF6);
675
INSERT INTO t1 VALUES(0xABF7);
676
INSERT INTO t1 VALUES(0xABF8);
677
INSERT INTO t1 VALUES(0xABF9);
678
INSERT INTO t1 VALUES(0xABFA);
679
INSERT INTO t1 VALUES(0xABFB);
680
INSERT INTO t1 VALUES(0xABFC);
681
INSERT INTO t1 VALUES(0xABFD);
682
INSERT INTO t1 VALUES(0xABFE);
683
INSERT INTO t1 VALUES(0xACA1);
684
INSERT INTO t1 VALUES(0xACA2);
685
INSERT INTO t1 VALUES(0xACA3);
686
INSERT INTO t1 VALUES(0xACA4);
687
INSERT INTO t1 VALUES(0xACA5);
688
INSERT INTO t1 VALUES(0xACA6);
689
INSERT INTO t1 VALUES(0xACA7);
690
INSERT INTO t1 VALUES(0xACA8);
691
INSERT INTO t1 VALUES(0xACA9);
692
INSERT INTO t1 VALUES(0xACAA);
693
INSERT INTO t1 VALUES(0xACAB);
694
INSERT INTO t1 VALUES(0xACAC);
695
INSERT INTO t1 VALUES(0xACAD);
696
INSERT INTO t1 VALUES(0xACAE);
697
INSERT INTO t1 VALUES(0xACAF);
698
INSERT INTO t1 VALUES(0xACB0);
699
INSERT INTO t1 VALUES(0xACB1);
700
INSERT INTO t1 VALUES(0xACB2);
701
INSERT INTO t1 VALUES(0xACB3);
702
INSERT INTO t1 VALUES(0xACB4);
703
INSERT INTO t1 VALUES(0xACB5);
704
INSERT INTO t1 VALUES(0xACB6);
705
INSERT INTO t1 VALUES(0xACB7);
706
INSERT INTO t1 VALUES(0xACB8);
707
INSERT INTO t1 VALUES(0xACB9);
708
INSERT INTO t1 VALUES(0xACBA);
709
INSERT INTO t1 VALUES(0xACBB);
710
INSERT INTO t1 VALUES(0xACBC);
711
INSERT INTO t1 VALUES(0xACBD);
712
INSERT INTO t1 VALUES(0xACBE);
713
INSERT INTO t1 VALUES(0xACBF);
714
INSERT INTO t1 VALUES(0xACC0);
715
INSERT INTO t1 VALUES(0xACC1);
716
INSERT INTO t1 VALUES(0xACC2);
717
INSERT INTO t1 VALUES(0xACC3);
718
INSERT INTO t1 VALUES(0xACC4);
719
INSERT INTO t1 VALUES(0xACC5);
720
INSERT INTO t1 VALUES(0xACC6);
721
INSERT INTO t1 VALUES(0xACC7);
722
INSERT INTO t1 VALUES(0xACC8);
723
INSERT INTO t1 VALUES(0xACC9);
724
INSERT INTO t1 VALUES(0xACCA);
725
INSERT INTO t1 VALUES(0xACCB);
726
INSERT INTO t1 VALUES(0xACCC);
727
INSERT INTO t1 VALUES(0xACCD);
728
INSERT INTO t1 VALUES(0xACCE);
729
INSERT INTO t1 VALUES(0xACCF);
730
INSERT INTO t1 VALUES(0xACD0);
731
INSERT INTO t1 VALUES(0xACD1);
732
INSERT INTO t1 VALUES(0xACD2);
733
INSERT INTO t1 VALUES(0xACD3);
734
INSERT INTO t1 VALUES(0xACD4);
735
INSERT INTO t1 VALUES(0xACD5);
736
INSERT INTO t1 VALUES(0xACD6);
737
INSERT INTO t1 VALUES(0xACD7);
738
INSERT INTO t1 VALUES(0xACD8);
739
INSERT INTO t1 VALUES(0xACD9);
740
INSERT INTO t1 VALUES(0xACDA);
741
INSERT INTO t1 VALUES(0xACDB);
742
INSERT INTO t1 VALUES(0xACDC);
743
INSERT INTO t1 VALUES(0xACDD);
744
INSERT INTO t1 VALUES(0xACDE);
745
INSERT INTO t1 VALUES(0xACDF);
746
INSERT INTO t1 VALUES(0xACE0);
747
INSERT INTO t1 VALUES(0xACE1);
748
INSERT INTO t1 VALUES(0xACE2);
749
INSERT INTO t1 VALUES(0xACE3);
750
INSERT INTO t1 VALUES(0xACE4);
751
INSERT INTO t1 VALUES(0xACE5);
752
INSERT INTO t1 VALUES(0xACE6);
753
INSERT INTO t1 VALUES(0xACE7);
754
INSERT INTO t1 VALUES(0xACE8);
755
INSERT INTO t1 VALUES(0xACE9);
756
INSERT INTO t1 VALUES(0xACEA);
757
INSERT INTO t1 VALUES(0xACEB);
758
INSERT INTO t1 VALUES(0xACEC);
759
INSERT INTO t1 VALUES(0xACED);
760
INSERT INTO t1 VALUES(0xACEE);
761
INSERT INTO t1 VALUES(0xACEF);
762
INSERT INTO t1 VALUES(0xACF0);
763
INSERT INTO t1 VALUES(0xACF1);
764
INSERT INTO t1 VALUES(0xACF2);
765
INSERT INTO t1 VALUES(0xACF3);
766
INSERT INTO t1 VALUES(0xACF4);
767
INSERT INTO t1 VALUES(0xACF5);
768
INSERT INTO t1 VALUES(0xACF6);
769
INSERT INTO t1 VALUES(0xACF7);
770
INSERT INTO t1 VALUES(0xACF8);
771
INSERT INTO t1 VALUES(0xACF9);
772
INSERT INTO t1 VALUES(0xACFA);
773
INSERT INTO t1 VALUES(0xACFB);
774
INSERT INTO t1 VALUES(0xACFC);
775
INSERT INTO t1 VALUES(0xACFD);
776
INSERT INTO t1 VALUES(0xACFE);
777
INSERT INTO t1 VALUES(0xADA1);
778
INSERT INTO t1 VALUES(0xADA2);
779
INSERT INTO t1 VALUES(0xADA3);
780
INSERT INTO t1 VALUES(0xADA4);
781
INSERT INTO t1 VALUES(0xADA5);
782
INSERT INTO t1 VALUES(0xADA6);
783
INSERT INTO t1 VALUES(0xADA7);
784
INSERT INTO t1 VALUES(0xADA8);
785
INSERT INTO t1 VALUES(0xADA9);
786
INSERT INTO t1 VALUES(0xADAA);
787
INSERT INTO t1 VALUES(0xADAB);
788
INSERT INTO t1 VALUES(0xADAC);
789
INSERT INTO t1 VALUES(0xADAD);
790
INSERT INTO t1 VALUES(0xADAE);
791
INSERT INTO t1 VALUES(0xADAF);
792
INSERT INTO t1 VALUES(0xADB0);
793
INSERT INTO t1 VALUES(0xADB1);
794
INSERT INTO t1 VALUES(0xADB2);
795
INSERT INTO t1 VALUES(0xADB3);
796
INSERT INTO t1 VALUES(0xADB4);
797
INSERT INTO t1 VALUES(0xADB5);
798
INSERT INTO t1 VALUES(0xADB6);
799
INSERT INTO t1 VALUES(0xADB7);
800
INSERT INTO t1 VALUES(0xADB8);
801
INSERT INTO t1 VALUES(0xADB9);
802
INSERT INTO t1 VALUES(0xADBA);
803
INSERT INTO t1 VALUES(0xADBB);
804
INSERT INTO t1 VALUES(0xADBC);
805
INSERT INTO t1 VALUES(0xADBD);
806
INSERT INTO t1 VALUES(0xADBE);
807
INSERT INTO t1 VALUES(0xADBF);
808
INSERT INTO t1 VALUES(0xADC0);
809
INSERT INTO t1 VALUES(0xADC1);
810
INSERT INTO t1 VALUES(0xADC2);
811
INSERT INTO t1 VALUES(0xADC3);
812
INSERT INTO t1 VALUES(0xADC4);
813
INSERT INTO t1 VALUES(0xADC5);
814
INSERT INTO t1 VALUES(0xADC6);
815
INSERT INTO t1 VALUES(0xADC7);
816
INSERT INTO t1 VALUES(0xADC8);
817
INSERT INTO t1 VALUES(0xADC9);
818
INSERT INTO t1 VALUES(0xADCA);
819
INSERT INTO t1 VALUES(0xADCB);
820
INSERT INTO t1 VALUES(0xADCC);
821
INSERT INTO t1 VALUES(0xADCD);
822
INSERT INTO t1 VALUES(0xADCE);
823
INSERT INTO t1 VALUES(0xADCF);
824
INSERT INTO t1 VALUES(0xADD0);
825
INSERT INTO t1 VALUES(0xADD1);
826
INSERT INTO t1 VALUES(0xADD2);
827
INSERT INTO t1 VALUES(0xADD3);
828
INSERT INTO t1 VALUES(0xADD4);
829
INSERT INTO t1 VALUES(0xADD5);
830
INSERT INTO t1 VALUES(0xADD6);
831
INSERT INTO t1 VALUES(0xADD7);
832
INSERT INTO t1 VALUES(0xADD8);
833
INSERT INTO t1 VALUES(0xADD9);
834
INSERT INTO t1 VALUES(0xADDA);
835
INSERT INTO t1 VALUES(0xADDB);
836
INSERT INTO t1 VALUES(0xADDC);
837
INSERT INTO t1 VALUES(0xADDD);
838
INSERT INTO t1 VALUES(0xADDE);
839
INSERT INTO t1 VALUES(0xADDF);
840
INSERT INTO t1 VALUES(0xADE0);
841
INSERT INTO t1 VALUES(0xADE1);
842
INSERT INTO t1 VALUES(0xADE2);
843
INSERT INTO t1 VALUES(0xADE3);
844
INSERT INTO t1 VALUES(0xADE4);
845
INSERT INTO t1 VALUES(0xADE5);
846
INSERT INTO t1 VALUES(0xADE6);
847
INSERT INTO t1 VALUES(0xADE7);
848
INSERT INTO t1 VALUES(0xADE8);
849
INSERT INTO t1 VALUES(0xADE9);
850
INSERT INTO t1 VALUES(0xADEA);
851
INSERT INTO t1 VALUES(0xADEB);
852
INSERT INTO t1 VALUES(0xADEC);
853
INSERT INTO t1 VALUES(0xADED);
854
INSERT INTO t1 VALUES(0xADEE);
855
INSERT INTO t1 VALUES(0xADEF);
856
INSERT INTO t1 VALUES(0xADF0);
857
INSERT INTO t1 VALUES(0xADF1);
858
INSERT INTO t1 VALUES(0xADF2);
859
INSERT INTO t1 VALUES(0xADF3);
860
INSERT INTO t1 VALUES(0xADF4);
861
INSERT INTO t1 VALUES(0xADF5);
862
INSERT INTO t1 VALUES(0xADF6);
863
INSERT INTO t1 VALUES(0xADF7);
864
INSERT INTO t1 VALUES(0xADF8);
865
INSERT INTO t1 VALUES(0xADF9);
866
INSERT INTO t1 VALUES(0xADFA);
867
INSERT INTO t1 VALUES(0xADFB);
868
INSERT INTO t1 VALUES(0xADFC);
869
INSERT INTO t1 VALUES(0xADFD);
870
INSERT INTO t1 VALUES(0xADFE);
871
INSERT INTO t1 VALUES(0xAEA1);
872
INSERT INTO t1 VALUES(0xAEA2);
873
INSERT INTO t1 VALUES(0xAEA3);
874
INSERT INTO t1 VALUES(0xAEA4);
875
INSERT INTO t1 VALUES(0xAEA5);
876
INSERT INTO t1 VALUES(0xAEA6);
877
INSERT INTO t1 VALUES(0xAEA7);
878
INSERT INTO t1 VALUES(0xAEA8);
879
INSERT INTO t1 VALUES(0xAEA9);
880
INSERT INTO t1 VALUES(0xAEAA);
881
INSERT INTO t1 VALUES(0xAEAB);
882
INSERT INTO t1 VALUES(0xAEAC);
883
INSERT INTO t1 VALUES(0xAEAD);
884
INSERT INTO t1 VALUES(0xAEAE);
885
INSERT INTO t1 VALUES(0xAEAF);
886
INSERT INTO t1 VALUES(0xAEB0);
887
INSERT INTO t1 VALUES(0xAEB1);
888
INSERT INTO t1 VALUES(0xAEB2);
889
INSERT INTO t1 VALUES(0xAEB3);
890
INSERT INTO t1 VALUES(0xAEB4);
891
INSERT INTO t1 VALUES(0xAEB5);
892
INSERT INTO t1 VALUES(0xAEB6);
893
INSERT INTO t1 VALUES(0xAEB7);
894
INSERT INTO t1 VALUES(0xAEB8);
895
INSERT INTO t1 VALUES(0xAEB9);
896
INSERT INTO t1 VALUES(0xAEBA);
897
INSERT INTO t1 VALUES(0xAEBB);
898
INSERT INTO t1 VALUES(0xAEBC);
899
INSERT INTO t1 VALUES(0xAEBD);
900
INSERT INTO t1 VALUES(0xAEBE);
901
INSERT INTO t1 VALUES(0xAEBF);
902
INSERT INTO t1 VALUES(0xAEC0);
903
INSERT INTO t1 VALUES(0xAEC1);
904
INSERT INTO t1 VALUES(0xAEC2);
905
INSERT INTO t1 VALUES(0xAEC3);
906
INSERT INTO t1 VALUES(0xAEC4);
907
INSERT INTO t1 VALUES(0xAEC5);
908
INSERT INTO t1 VALUES(0xAEC6);
909
INSERT INTO t1 VALUES(0xAEC7);
910
INSERT INTO t1 VALUES(0xAEC8);
911
INSERT INTO t1 VALUES(0xAEC9);
912
INSERT INTO t1 VALUES(0xAECA);
913
INSERT INTO t1 VALUES(0xAECB);
914
INSERT INTO t1 VALUES(0xAECC);
915
INSERT INTO t1 VALUES(0xAECD);
916
INSERT INTO t1 VALUES(0xAECE);
917
INSERT INTO t1 VALUES(0xAECF);
918
INSERT INTO t1 VALUES(0xAED0);
919
INSERT INTO t1 VALUES(0xAED1);
920
INSERT INTO t1 VALUES(0xAED2);
921
INSERT INTO t1 VALUES(0xAED3);
922
INSERT INTO t1 VALUES(0xAED4);
923
INSERT INTO t1 VALUES(0xAED5);
924
INSERT INTO t1 VALUES(0xAED6);
925
INSERT INTO t1 VALUES(0xAED7);
926
INSERT INTO t1 VALUES(0xAED8);
927
INSERT INTO t1 VALUES(0xAED9);
928
INSERT INTO t1 VALUES(0xAEDA);
929
INSERT INTO t1 VALUES(0xAEDB);
930
INSERT INTO t1 VALUES(0xAEDC);
931
INSERT INTO t1 VALUES(0xAEDD);
932
INSERT INTO t1 VALUES(0xAEDE);
933
INSERT INTO t1 VALUES(0xAEDF);
934
INSERT INTO t1 VALUES(0xAEE0);
935
INSERT INTO t1 VALUES(0xAEE1);
936
INSERT INTO t1 VALUES(0xAEE2);
937
INSERT INTO t1 VALUES(0xAEE3);
938
INSERT INTO t1 VALUES(0xAEE4);
939
INSERT INTO t1 VALUES(0xAEE5);
940
INSERT INTO t1 VALUES(0xAEE6);
941
INSERT INTO t1 VALUES(0xAEE7);
942
INSERT INTO t1 VALUES(0xAEE8);
943
INSERT INTO t1 VALUES(0xAEE9);
944
INSERT INTO t1 VALUES(0xAEEA);
945
INSERT INTO t1 VALUES(0xAEEB);
946
INSERT INTO t1 VALUES(0xAEEC);
947
INSERT INTO t1 VALUES(0xAEED);
948
INSERT INTO t1 VALUES(0xAEEE);
949
INSERT INTO t1 VALUES(0xAEEF);
950
INSERT INTO t1 VALUES(0xAEF0);
951
INSERT INTO t1 VALUES(0xAEF1);
952
INSERT INTO t1 VALUES(0xAEF2);
953
INSERT INTO t1 VALUES(0xAEF3);
954
INSERT INTO t1 VALUES(0xAEF4);
955
INSERT INTO t1 VALUES(0xAEF5);
956
INSERT INTO t1 VALUES(0xAEF6);
957
INSERT INTO t1 VALUES(0xAEF7);
958
INSERT INTO t1 VALUES(0xAEF8);
959
INSERT INTO t1 VALUES(0xAEF9);
960
INSERT INTO t1 VALUES(0xAEFA);
961
INSERT INTO t1 VALUES(0xAEFB);
962
INSERT INTO t1 VALUES(0xAEFC);
963
INSERT INTO t1 VALUES(0xAEFD);
964
INSERT INTO t1 VALUES(0xAEFE);
965
INSERT INTO t1 VALUES(0xAFA1);
966
INSERT INTO t1 VALUES(0xAFA2);
967
INSERT INTO t1 VALUES(0xAFA3);
968
INSERT INTO t1 VALUES(0xAFA4);
969
INSERT INTO t1 VALUES(0xAFA5);
970
INSERT INTO t1 VALUES(0xAFA6);
971
INSERT INTO t1 VALUES(0xAFA7);
972
INSERT INTO t1 VALUES(0xAFA8);
973
INSERT INTO t1 VALUES(0xAFA9);
974
INSERT INTO t1 VALUES(0xAFAA);
975
INSERT INTO t1 VALUES(0xAFAB);
976
INSERT INTO t1 VALUES(0xAFAC);
977
INSERT INTO t1 VALUES(0xAFAD);
978
INSERT INTO t1 VALUES(0xAFAE);
979
INSERT INTO t1 VALUES(0xAFAF);
980
INSERT INTO t1 VALUES(0xAFB0);
981
INSERT INTO t1 VALUES(0xAFB1);
982
INSERT INTO t1 VALUES(0xAFB2);
983
INSERT INTO t1 VALUES(0xAFB3);
984
INSERT INTO t1 VALUES(0xAFB4);
985
INSERT INTO t1 VALUES(0xAFB5);
986
INSERT INTO t1 VALUES(0xAFB6);
987
INSERT INTO t1 VALUES(0xAFB7);
988
INSERT INTO t1 VALUES(0xAFB8);
989
INSERT INTO t1 VALUES(0xAFB9);
990
INSERT INTO t1 VALUES(0xAFBA);
991
INSERT INTO t1 VALUES(0xAFBB);
992
INSERT INTO t1 VALUES(0xAFBC);
993
INSERT INTO t1 VALUES(0xAFBD);
994
INSERT INTO t1 VALUES(0xAFBE);
995
INSERT INTO t1 VALUES(0xAFBF);
996
INSERT INTO t1 VALUES(0xAFC0);
997
INSERT INTO t1 VALUES(0xAFC1);
998
INSERT INTO t1 VALUES(0xAFC2);
999
INSERT INTO t1 VALUES(0xAFC3);
1000
INSERT INTO t1 VALUES(0xAFC4);
1001
INSERT INTO t1 VALUES(0xAFC5);
1002
INSERT INTO t1 VALUES(0xAFC6);
1003
INSERT INTO t1 VALUES(0xAFC7);
1004
INSERT INTO t1 VALUES(0xAFC8);
1005
INSERT INTO t1 VALUES(0xAFC9);
1006
INSERT INTO t1 VALUES(0xAFCA);
1007
INSERT INTO t1 VALUES(0xAFCB);
1008
INSERT INTO t1 VALUES(0xAFCC);
1009
INSERT INTO t1 VALUES(0xAFCD);
1010
INSERT INTO t1 VALUES(0xAFCE);
1011
INSERT INTO t1 VALUES(0xAFCF);
1012
INSERT INTO t1 VALUES(0xAFD0);
1013
INSERT INTO t1 VALUES(0xAFD1);
1014
INSERT INTO t1 VALUES(0xAFD2);
1015
INSERT INTO t1 VALUES(0xAFD3);
1016
INSERT INTO t1 VALUES(0xAFD4);
1017
INSERT INTO t1 VALUES(0xAFD5);
1018
INSERT INTO t1 VALUES(0xAFD6);
1019
INSERT INTO t1 VALUES(0xAFD7);
1020
INSERT INTO t1 VALUES(0xAFD8);
1021
INSERT INTO t1 VALUES(0xAFD9);
1022
INSERT INTO t1 VALUES(0xAFDA);
1023
INSERT INTO t1 VALUES(0xAFDB);
1024
INSERT INTO t1 VALUES(0xAFDC);
1025
INSERT INTO t1 VALUES(0xAFDD);
1026
INSERT INTO t1 VALUES(0xAFDE);
1027
INSERT INTO t1 VALUES(0xAFDF);
1028
INSERT INTO t1 VALUES(0xAFE0);
1029
INSERT INTO t1 VALUES(0xAFE1);
1030
INSERT INTO t1 VALUES(0xAFE2);
1031
INSERT INTO t1 VALUES(0xAFE3);
1032
INSERT INTO t1 VALUES(0xAFE4);
1033
INSERT INTO t1 VALUES(0xAFE5);
1034
INSERT INTO t1 VALUES(0xAFE6);
1035
INSERT INTO t1 VALUES(0xAFE7);
1036
INSERT INTO t1 VALUES(0xAFE8);
1037
INSERT INTO t1 VALUES(0xAFE9);
1038
INSERT INTO t1 VALUES(0xAFEA);
1039
INSERT INTO t1 VALUES(0xAFEB);
1040
INSERT INTO t1 VALUES(0xAFEC);
1041
INSERT INTO t1 VALUES(0xAFED);
1042
INSERT INTO t1 VALUES(0xAFEE);
1043
INSERT INTO t1 VALUES(0xAFEF);
1044
INSERT INTO t1 VALUES(0xAFF0);
1045
INSERT INTO t1 VALUES(0xAFF1);
1046
INSERT INTO t1 VALUES(0xAFF2);
1047
INSERT INTO t1 VALUES(0xAFF3);
1048
INSERT INTO t1 VALUES(0xAFF4);
1049
INSERT INTO t1 VALUES(0xAFF5);
1050
INSERT INTO t1 VALUES(0xAFF6);
1051
INSERT INTO t1 VALUES(0xAFF7);
1052
INSERT INTO t1 VALUES(0xAFF8);
1053
INSERT INTO t1 VALUES(0xAFF9);
1054
INSERT INTO t1 VALUES(0xAFFA);
1055
INSERT INTO t1 VALUES(0xAFFB);
1056
INSERT INTO t1 VALUES(0xAFFC);
1057
INSERT INTO t1 VALUES(0xAFFD);
1058
INSERT INTO t1 VALUES(0xAFFE);
1059
INSERT INTO t1 VALUES(0xCFD4);
1060
INSERT INTO t1 VALUES(0xCFD5);
1061
INSERT INTO t1 VALUES(0xCFD6);
1062
INSERT INTO t1 VALUES(0xCFD7);
1063
INSERT INTO t1 VALUES(0xCFD8);
1064
INSERT INTO t1 VALUES(0xCFD9);
1065
INSERT INTO t1 VALUES(0xCFDA);
1066
INSERT INTO t1 VALUES(0xCFDB);
1067
INSERT INTO t1 VALUES(0xCFDC);
1068
INSERT INTO t1 VALUES(0xCFDD);
1069
INSERT INTO t1 VALUES(0xCFDE);
1070
INSERT INTO t1 VALUES(0xCFDF);
1071
INSERT INTO t1 VALUES(0xCFE0);
1072
INSERT INTO t1 VALUES(0xCFE1);
1073
INSERT INTO t1 VALUES(0xCFE2);
1074
INSERT INTO t1 VALUES(0xCFE3);
1075
INSERT INTO t1 VALUES(0xCFE4);
1076
INSERT INTO t1 VALUES(0xCFE5);
1077
INSERT INTO t1 VALUES(0xCFE6);
1078
INSERT INTO t1 VALUES(0xCFE7);
1079
INSERT INTO t1 VALUES(0xCFE8);
1080
INSERT INTO t1 VALUES(0xCFE9);
1081
INSERT INTO t1 VALUES(0xCFEA);
1082
INSERT INTO t1 VALUES(0xCFEB);
1083
INSERT INTO t1 VALUES(0xCFEC);
1084
INSERT INTO t1 VALUES(0xCFED);
1085
INSERT INTO t1 VALUES(0xCFEE);
1086
INSERT INTO t1 VALUES(0xCFEF);
1087
INSERT INTO t1 VALUES(0xCFF0);
1088
INSERT INTO t1 VALUES(0xCFF1);
1089
INSERT INTO t1 VALUES(0xCFF2);
1090
INSERT INTO t1 VALUES(0xCFF3);
1091
INSERT INTO t1 VALUES(0xCFF4);
1092
INSERT INTO t1 VALUES(0xCFF5);
1093
INSERT INTO t1 VALUES(0xCFF6);
1094
INSERT INTO t1 VALUES(0xCFF7);
1095
INSERT INTO t1 VALUES(0xCFF8);
1096
INSERT INTO t1 VALUES(0xCFF9);
1097
INSERT INTO t1 VALUES(0xCFFA);
1098
INSERT INTO t1 VALUES(0xCFFB);
1099
INSERT INTO t1 VALUES(0xCFFC);
1100
INSERT INTO t1 VALUES(0xCFFD);
1101
INSERT INTO t1 VALUES(0xCFFE);
1102
INSERT INTO t1 VALUES(0xF4A7);
1103
INSERT INTO t1 VALUES(0xF4A8);
1104
INSERT INTO t1 VALUES(0xF4A9);
1105
INSERT INTO t1 VALUES(0xF4AA);
1106
INSERT INTO t1 VALUES(0xF4AB);
1107
INSERT INTO t1 VALUES(0xF4AC);
1108
INSERT INTO t1 VALUES(0xF4AD);
1109
INSERT INTO t1 VALUES(0xF4AE);
1110
INSERT INTO t1 VALUES(0xF4AF);
1111
INSERT INTO t1 VALUES(0xF4B0);
1112
INSERT INTO t1 VALUES(0xF4B1);
1113
INSERT INTO t1 VALUES(0xF4B2);
1114
INSERT INTO t1 VALUES(0xF4B3);
1115
INSERT INTO t1 VALUES(0xF4B4);
1116
INSERT INTO t1 VALUES(0xF4B5);
1117
INSERT INTO t1 VALUES(0xF4B6);
1118
INSERT INTO t1 VALUES(0xF4B7);
1119
INSERT INTO t1 VALUES(0xF4B8);
1120
INSERT INTO t1 VALUES(0xF4B9);
1121
INSERT INTO t1 VALUES(0xF4BA);
1122
INSERT INTO t1 VALUES(0xF4BB);
1123
INSERT INTO t1 VALUES(0xF4BC);
1124
INSERT INTO t1 VALUES(0xF4BD);
1125
INSERT INTO t1 VALUES(0xF4BE);
1126
INSERT INTO t1 VALUES(0xF4BF);
1127
INSERT INTO t1 VALUES(0xF4C0);
1128
INSERT INTO t1 VALUES(0xF4C1);
1129
INSERT INTO t1 VALUES(0xF4C2);
1130
INSERT INTO t1 VALUES(0xF4C3);
1131
INSERT INTO t1 VALUES(0xF4C4);
1132
INSERT INTO t1 VALUES(0xF4C5);
1133
INSERT INTO t1 VALUES(0xF4C6);
1134
INSERT INTO t1 VALUES(0xF4C7);
1135
INSERT INTO t1 VALUES(0xF4C8);
1136
INSERT INTO t1 VALUES(0xF4C9);
1137
INSERT INTO t1 VALUES(0xF4CA);
1138
INSERT INTO t1 VALUES(0xF4CB);
1139
INSERT INTO t1 VALUES(0xF4CC);
1140
INSERT INTO t1 VALUES(0xF4CD);
1141
INSERT INTO t1 VALUES(0xF4CE);
1142
INSERT INTO t1 VALUES(0xF4CF);
1143
INSERT INTO t1 VALUES(0xF4D0);
1144
INSERT INTO t1 VALUES(0xF4D1);
1145
INSERT INTO t1 VALUES(0xF4D2);
1146
INSERT INTO t1 VALUES(0xF4D3);
1147
INSERT INTO t1 VALUES(0xF4D4);
1148
INSERT INTO t1 VALUES(0xF4D5);
1149
INSERT INTO t1 VALUES(0xF4D6);
1150
INSERT INTO t1 VALUES(0xF4D7);
1151
INSERT INTO t1 VALUES(0xF4D8);
1152
INSERT INTO t1 VALUES(0xF4D9);
1153
INSERT INTO t1 VALUES(0xF4DA);
1154
INSERT INTO t1 VALUES(0xF4DB);
1155
INSERT INTO t1 VALUES(0xF4DC);
1156
INSERT INTO t1 VALUES(0xF4DD);
1157
INSERT INTO t1 VALUES(0xF4DE);
1158
INSERT INTO t1 VALUES(0xF4DF);
1159
INSERT INTO t1 VALUES(0xF4E0);
1160
INSERT INTO t1 VALUES(0xF4E1);
1161
INSERT INTO t1 VALUES(0xF4E2);
1162
INSERT INTO t1 VALUES(0xF4E3);
1163
INSERT INTO t1 VALUES(0xF4E4);
1164
INSERT INTO t1 VALUES(0xF4E5);
1165
INSERT INTO t1 VALUES(0xF4E6);
1166
INSERT INTO t1 VALUES(0xF4E7);
1167
INSERT INTO t1 VALUES(0xF4E8);
1168
INSERT INTO t1 VALUES(0xF4E9);
1169
INSERT INTO t1 VALUES(0xF4EA);
1170
INSERT INTO t1 VALUES(0xF4EB);
1171
INSERT INTO t1 VALUES(0xF4EC);
1172
INSERT INTO t1 VALUES(0xF4ED);
1173
INSERT INTO t1 VALUES(0xF4EE);
1174
INSERT INTO t1 VALUES(0xF4EF);
1175
INSERT INTO t1 VALUES(0xF4F0);
1176
INSERT INTO t1 VALUES(0xF4F1);
1177
INSERT INTO t1 VALUES(0xF4F2);
1178
INSERT INTO t1 VALUES(0xF4F3);
1179
INSERT INTO t1 VALUES(0xF4F4);
1180
INSERT INTO t1 VALUES(0xF4F5);
1181
INSERT INTO t1 VALUES(0xF4F6);
1182
INSERT INTO t1 VALUES(0xF4F7);
1183
INSERT INTO t1 VALUES(0xF4F8);
1184
INSERT INTO t1 VALUES(0xF4F9);
1185
INSERT INTO t1 VALUES(0xF4FA);
1186
INSERT INTO t1 VALUES(0xF4FB);
1187
INSERT INTO t1 VALUES(0xF4FC);
1188
INSERT INTO t1 VALUES(0xF4FD);
1189
INSERT INTO t1 VALUES(0xF4FE);
1190
SELECT HEX(c) FROM t1 ORDER BY BINARY c;
2210
SET collation_connection='ujis_japanese_ci';
2211
create table t1 select repeat('a',4000) a;
2213
insert into t1 values ('a'), ('a '), ('a\t');
2214
select collation(a),hex(a) from t1 order by a;
2216
ujis_japanese_ci 6109
2218
ujis_japanese_ci 6120
2220
create table t1 engine=innodb select repeat('a',50) as c1;
2221
alter table t1 add index(c1(5));
2222
insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111');
2223
select collation(c1) from t1 limit 1;
2226
select c1 from t1 where c1 like 'abcdef%' order by c1;
2229
select c1 from t1 where c1 like 'abcde1%' order by c1;
2234
select c1 from t1 where c1 like 'abcde11%' order by c1;
2238
select c1 from t1 where c1 like 'abcde111%' order by c1;
2242
select @@collation_connection;
2243
@@collation_connection
2245
create table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ;
2246
insert into t1 values('abcdef');
2247
insert into t1 values('_bcdef');
2248
insert into t1 values('a_cdef');
2249
insert into t1 values('ab_def');
2250
insert into t1 values('abc_ef');
2251
insert into t1 values('abcd_f');
2252
insert into t1 values('abcde_');
2253
select c1 as c1u from t1 where c1 like 'ab\_def';
2256
select c1 as c2h from t1 where c1 like 'ab#_def' escape '#';
2261
SELECT 10 AS a, REPEAT('a',20) AS b, REPEAT('a',8) AS c, REPEAT('a',8) AS d;
2262
ALTER TABLE t1 ADD PRIMARY KEY(a), ADD KEY(b);
2263
INSERT INTO t1 (a, b) VALUES (1, repeat(0xF1F2,5));
2264
INSERT INTO t1 (a, b) VALUES (2, repeat(0xF1F2,10));
2265
INSERT INTO t1 (a, b) VALUES (3, repeat(0xF1F2,11));
2266
INSERT INTO t1 (a, b) VALUES (4, repeat(0xF1F2,12));
2267
SELECT hex(concat(repeat(0xF1F2, 10), '%'));
2268
hex(concat(repeat(0xF1F2, 10), '%'))
2269
F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F225
2271
SELECT a, hex(b), c FROM t1 WHERE b LIKE concat(repeat(0xF1F2,10), '%');
2273
2 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2
2274
3 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2
2275
4 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2
2277
SET collation_connection='ujis_bin';
2278
create table t1 select repeat('a',4000) a;
2280
insert into t1 values ('a'), ('a '), ('a\t');
2281
select collation(a),hex(a) from t1 order by a;
2287
create table t1 engine=innodb select repeat('a',50) as c1;
2288
alter table t1 add index(c1(5));
2289
insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111');
2290
select collation(c1) from t1 limit 1;
2293
select c1 from t1 where c1 like 'abcdef%' order by c1;
2296
select c1 from t1 where c1 like 'abcde1%' order by c1;
2301
select c1 from t1 where c1 like 'abcde11%' order by c1;
2305
select c1 from t1 where c1 like 'abcde111%' order by c1;
2309
select @@collation_connection;
2310
@@collation_connection
2312
create table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ;
2313
insert into t1 values('abcdef');
2314
insert into t1 values('_bcdef');
2315
insert into t1 values('a_cdef');
2316
insert into t1 values('ab_def');
2317
insert into t1 values('abc_ef');
2318
insert into t1 values('abcd_f');
2319
insert into t1 values('abcde_');
2320
select c1 as c1u from t1 where c1 like 'ab\_def';
2323
select c1 as c2h from t1 where c1 like 'ab#_def' escape '#';
2328
SELECT 10 AS a, REPEAT('a',20) AS b, REPEAT('a',8) AS c, REPEAT('a',8) AS d;
2329
ALTER TABLE t1 ADD PRIMARY KEY(a), ADD KEY(b);
2330
INSERT INTO t1 (a, b) VALUES (1, repeat(0xF1F2,5));
2331
INSERT INTO t1 (a, b) VALUES (2, repeat(0xF1F2,10));
2332
INSERT INTO t1 (a, b) VALUES (3, repeat(0xF1F2,11));
2333
INSERT INTO t1 (a, b) VALUES (4, repeat(0xF1F2,12));
2334
SELECT hex(concat(repeat(0xF1F2, 10), '%'));
2335
hex(concat(repeat(0xF1F2, 10), '%'))
2336
F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F225
2338
SELECT a, hex(b), c FROM t1 WHERE b LIKE concat(repeat(0xF1F2,10), '%');
2340
2 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2
2341
3 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2
2342
4 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2
2344
select hex(convert(_ujis 0xA5FE41 using ucs2));
2345
hex(convert(_ujis 0xA5FE41 using ucs2))
2347
select hex(convert(_ujis 0x8FABF841 using ucs2));
2348
hex(convert(_ujis 0x8FABF841 using ucs2))
2350
DROP TABLE IF EXISTS t1, t2;
2351
DROP PROCEDURE IF EXISTS sp1;
2353
set character_set_database = ujis;
2354
set character_set_server = ujis;
2355
CREATE TABLE t1(c1 char(2)) default charset = ujis;
2356
CREATE TABLE t2(c2 char(2)) default charset = ujis;
2357
INSERT INTO t1 VALUES(_ujis 0xA4A2);
2358
CREATE PROCEDURE sp1()
2360
DECLARE a CHAR(2) CHARSET ujis;
2361
DECLARE cur1 CURSOR FOR SELECT c1 FROM t1;
2364
INSERT INTO t2 VALUES (a);
2368
SELECT c1,c2 FROM t1,t2;
2371
SELECT hex(convert(_latin1 0xA4A2 using ujis)),hex(c2) FROM t1,t2;
2372
hex(convert(_latin1 0xA4A2 using ujis)) hex(c2)
2378
set character_set_database=default;
2379
set character_set_server=default;
2382
select @@collation_connection;
2383
@@collation_connection
2385
select hex(weight_string('a'));
2386
hex(weight_string('a'))
2388
select hex(weight_string('A'));
2389
hex(weight_string('A'))
2391
select hex(weight_string('abc'));
2392
hex(weight_string('abc'))
2394
select hex(weight_string('abc' as char(2)));
2395
hex(weight_string('abc' as char(2)))
2397
select hex(weight_string('abc' as char(3)));
2398
hex(weight_string('abc' as char(3)))
2400
select hex(weight_string('abc' as char(5)));
2401
hex(weight_string('abc' as char(5)))
2403
select @@collation_connection;
2404
@@collation_connection
2406
select hex(weight_string('a' LEVEL 1));
2407
hex(weight_string('a' LEVEL 1))
2409
select hex(weight_string('A' LEVEL 1));
2410
hex(weight_string('A' LEVEL 1))
2412
select hex(weight_string('abc' LEVEL 1));
2413
hex(weight_string('abc' LEVEL 1))
2415
select hex(weight_string('abc' as char(2) LEVEL 1));
2416
hex(weight_string('abc' as char(2) LEVEL 1))
2418
select hex(weight_string('abc' as char(3) LEVEL 1));
2419
hex(weight_string('abc' as char(3) LEVEL 1))
2421
select hex(weight_string('abc' as char(5) LEVEL 1));
2422
hex(weight_string('abc' as char(5) LEVEL 1))
2424
select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE));
2425
hex(weight_string('abc' as char(5) LEVEL 1 REVERSE))
2427
select hex(weight_string('abc' as char(5) LEVEL 1 DESC));
2428
hex(weight_string('abc' as char(5) LEVEL 1 DESC))
2430
select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE));
2431
hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE))
2433
select collation(cast(0xA1A1 as char));
2434
collation(cast(0xA1A1 as char))
2436
select hex(weight_string(cast(0x6141 as char)));
2437
hex(weight_string(cast(0x6141 as char)))
2439
select hex(weight_string(cast(0xA1A1 as char)));
2440
hex(weight_string(cast(0xA1A1 as char)))
2442
select hex(weight_string(cast(0xA1A1 as char) as char(1)));
2443
hex(weight_string(cast(0xA1A1 as char) as char(1)))
2445
select hex(weight_string(cast(0xA1A1A1A1 as char) as char(1)));
2446
hex(weight_string(cast(0xA1A1A1A1 as char) as char(1)))
2448
select hex(weight_string(cast(0xA1A1 as char) as char(3)));
2449
hex(weight_string(cast(0xA1A1 as char) as char(3)))
2451
select hex(weight_string(cast(0xA1A1A1A1 as char) as char(3)));
2452
hex(weight_string(cast(0xA1A1A1A1 as char) as char(3)))
2454
select hex(weight_string(cast(0x40A1A1 as char) as char(3)));
2455
hex(weight_string(cast(0x40A1A1 as char) as char(3)))
2457
select hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3)));
2458
hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3)))
2460
select hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3)));
2461
hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3)))
2463
select hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3)));
2464
hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3)))
2466
select collation(cast(0xA1A1 as char));
2467
collation(cast(0xA1A1 as char))
2469
select hex(weight_string(cast(0x6141 as char)));
2470
hex(weight_string(cast(0x6141 as char)))
2472
select hex(weight_string(cast(0x8EA1 as char)));
2473
hex(weight_string(cast(0x8EA1 as char)))
2475
select hex(weight_string(cast(0x8EA1 as char) as char(1)));
2476
hex(weight_string(cast(0x8EA1 as char) as char(1)))
2478
select hex(weight_string(cast(0x8EA18EA1 as char) as char(1)));
2479
hex(weight_string(cast(0x8EA18EA1 as char) as char(1)))
2481
select hex(weight_string(cast(0x8EA1 as char) as char(3)));
2482
hex(weight_string(cast(0x8EA1 as char) as char(3)))
2484
select hex(weight_string(cast(0x8EA18EA1 as char) as char(3)));
2485
hex(weight_string(cast(0x8EA18EA1 as char) as char(3)))
2487
select hex(weight_string(cast(0x408EA1 as char) as char(3)));
2488
hex(weight_string(cast(0x408EA1 as char) as char(3)))
2490
select hex(weight_string(cast(0x408EA18EA1 as char) as char(3)));
2491
hex(weight_string(cast(0x408EA18EA1 as char) as char(3)))
2493
select hex(weight_string(cast(0x408EA18EA18EA1 as char) as char(3)));
2494
hex(weight_string(cast(0x408EA18EA18EA1 as char) as char(3)))
2496
select hex(weight_string(cast(0x40408EA18EA18EA1 as char) as char(3)));
2497
hex(weight_string(cast(0x40408EA18EA18EA1 as char) as char(3)))
2499
select collation(cast(0x8FA2C3 as char));
2500
collation(cast(0x8FA2C3 as char))
2502
select hex(weight_string(cast(0x6141 as char)));
2503
hex(weight_string(cast(0x6141 as char)))
2505
select hex(weight_string(cast(0x8FA2C3 as char)));
2506
hex(weight_string(cast(0x8FA2C3 as char)))
2508
select hex(weight_string(cast(0x8FA2C3 as char) as char(1)));
2509
hex(weight_string(cast(0x8FA2C3 as char) as char(1)))
2511
select hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(1)));
2512
hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(1)))
2514
select hex(weight_string(cast(0x8FA2C3 as char) as char(3)));
2515
hex(weight_string(cast(0x8FA2C3 as char) as char(3)))
2517
select hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(3)));
2518
hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(3)))
2520
select hex(weight_string(cast(0x408FA2C3 as char) as char(3)));
2521
hex(weight_string(cast(0x408FA2C3 as char) as char(3)))
2523
select hex(weight_string(cast(0x408FA2C38FA2C3 as char) as char(3)));
2524
hex(weight_string(cast(0x408FA2C38FA2C3 as char) as char(3)))
2526
select hex(weight_string(cast(0x408FA2C38FA2C38FA2C3 as char) as char(3)));
2527
hex(weight_string(cast(0x408FA2C38FA2C38FA2C3 as char) as char(3)))
2529
select hex(weight_string(cast(0x40408FA2C38FA2C38FA2C3 as char) as char(3)));
2530
hex(weight_string(cast(0x40408FA2C38FA2C38FA2C3 as char) as char(3)))
2532
set collation_connection=ujis_bin;
2533
select @@collation_connection;
2534
@@collation_connection
2536
select hex(weight_string('a'));
2537
hex(weight_string('a'))
2539
select hex(weight_string('A'));
2540
hex(weight_string('A'))
2542
select hex(weight_string('abc'));
2543
hex(weight_string('abc'))
2545
select hex(weight_string('abc' as char(2)));
2546
hex(weight_string('abc' as char(2)))
2548
select hex(weight_string('abc' as char(3)));
2549
hex(weight_string('abc' as char(3)))
2551
select hex(weight_string('abc' as char(5)));
2552
hex(weight_string('abc' as char(5)))
2554
select @@collation_connection;
2555
@@collation_connection
2557
select hex(weight_string('a' LEVEL 1));
2558
hex(weight_string('a' LEVEL 1))
2560
select hex(weight_string('A' LEVEL 1));
2561
hex(weight_string('A' LEVEL 1))
2563
select hex(weight_string('abc' LEVEL 1));
2564
hex(weight_string('abc' LEVEL 1))
2566
select hex(weight_string('abc' as char(2) LEVEL 1));
2567
hex(weight_string('abc' as char(2) LEVEL 1))
2569
select hex(weight_string('abc' as char(3) LEVEL 1));
2570
hex(weight_string('abc' as char(3) LEVEL 1))
2572
select hex(weight_string('abc' as char(5) LEVEL 1));
2573
hex(weight_string('abc' as char(5) LEVEL 1))
2575
select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE));
2576
hex(weight_string('abc' as char(5) LEVEL 1 REVERSE))
2578
select hex(weight_string('abc' as char(5) LEVEL 1 DESC));
2579
hex(weight_string('abc' as char(5) LEVEL 1 DESC))
2581
select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE));
2582
hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE))
2584
select collation(cast(0xA1A1 as char));
2585
collation(cast(0xA1A1 as char))
2587
select hex(weight_string(cast(0x6141 as char)));
2588
hex(weight_string(cast(0x6141 as char)))
2590
select hex(weight_string(cast(0xA1A1 as char)));
2591
hex(weight_string(cast(0xA1A1 as char)))
2593
select hex(weight_string(cast(0xA1A1 as char) as char(1)));
2594
hex(weight_string(cast(0xA1A1 as char) as char(1)))
2596
select hex(weight_string(cast(0xA1A1A1A1 as char) as char(1)));
2597
hex(weight_string(cast(0xA1A1A1A1 as char) as char(1)))
2599
select hex(weight_string(cast(0xA1A1 as char) as char(3)));
2600
hex(weight_string(cast(0xA1A1 as char) as char(3)))
2602
select hex(weight_string(cast(0xA1A1A1A1 as char) as char(3)));
2603
hex(weight_string(cast(0xA1A1A1A1 as char) as char(3)))
2605
select hex(weight_string(cast(0x40A1A1 as char) as char(3)));
2606
hex(weight_string(cast(0x40A1A1 as char) as char(3)))
2608
select hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3)));
2609
hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3)))
2611
select hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3)));
2612
hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3)))
2614
select hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3)));
2615
hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3)))
2617
select collation(cast(0xA1A1 as char));
2618
collation(cast(0xA1A1 as char))
2620
select hex(weight_string(cast(0x6141 as char)));
2621
hex(weight_string(cast(0x6141 as char)))
2623
select hex(weight_string(cast(0x8EA1 as char)));
2624
hex(weight_string(cast(0x8EA1 as char)))
2626
select hex(weight_string(cast(0x8EA1 as char) as char(1)));
2627
hex(weight_string(cast(0x8EA1 as char) as char(1)))
2629
select hex(weight_string(cast(0x8EA18EA1 as char) as char(1)));
2630
hex(weight_string(cast(0x8EA18EA1 as char) as char(1)))
2632
select hex(weight_string(cast(0x8EA1 as char) as char(3)));
2633
hex(weight_string(cast(0x8EA1 as char) as char(3)))
2635
select hex(weight_string(cast(0x8EA18EA1 as char) as char(3)));
2636
hex(weight_string(cast(0x8EA18EA1 as char) as char(3)))
2638
select hex(weight_string(cast(0x408EA1 as char) as char(3)));
2639
hex(weight_string(cast(0x408EA1 as char) as char(3)))
2641
select hex(weight_string(cast(0x408EA18EA1 as char) as char(3)));
2642
hex(weight_string(cast(0x408EA18EA1 as char) as char(3)))
2644
select hex(weight_string(cast(0x408EA18EA18EA1 as char) as char(3)));
2645
hex(weight_string(cast(0x408EA18EA18EA1 as char) as char(3)))
2647
select hex(weight_string(cast(0x40408EA18EA18EA1 as char) as char(3)));
2648
hex(weight_string(cast(0x40408EA18EA18EA1 as char) as char(3)))
2650
select collation(cast(0x8FA2C3 as char));
2651
collation(cast(0x8FA2C3 as char))
2653
select hex(weight_string(cast(0x6141 as char)));
2654
hex(weight_string(cast(0x6141 as char)))
2656
select hex(weight_string(cast(0x8FA2C3 as char)));
2657
hex(weight_string(cast(0x8FA2C3 as char)))
2659
select hex(weight_string(cast(0x8FA2C3 as char) as char(1)));
2660
hex(weight_string(cast(0x8FA2C3 as char) as char(1)))
2662
select hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(1)));
2663
hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(1)))
2665
select hex(weight_string(cast(0x8FA2C3 as char) as char(3)));
2666
hex(weight_string(cast(0x8FA2C3 as char) as char(3)))
2668
select hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(3)));
2669
hex(weight_string(cast(0x8FA2C38FA2C3 as char) as char(3)))
2671
select hex(weight_string(cast(0x408FA2C3 as char) as char(3)));
2672
hex(weight_string(cast(0x408FA2C3 as char) as char(3)))
2674
select hex(weight_string(cast(0x408FA2C38FA2C3 as char) as char(3)));
2675
hex(weight_string(cast(0x408FA2C38FA2C3 as char) as char(3)))
2677
select hex(weight_string(cast(0x408FA2C38FA2C38FA2C3 as char) as char(3)));
2678
hex(weight_string(cast(0x408FA2C38FA2C38FA2C3 as char) as char(3)))
2680
select hex(weight_string(cast(0x40408FA2C38FA2C38FA2C3 as char) as char(3)));
2681
hex(weight_string(cast(0x40408FA2C38FA2C38FA2C3 as char) as char(3)))