ctype_ujis.result

这是linux下运行的mysql软件包,可用于linux 下安装 php + mysql + apach 的网络配置

drop table if exists t1;
set names ujis;
create table t1 (c text character set ujis);
insert into t1 values (0xa4a2),(0xa4a3);
select hex(left(c,1)) from t1 group by c;
hex(left(c,1))
A4A2
A4A3
drop table t1;
select locate(0xa2a1,0xa1a2a1a3);
locate(0xa2a1,0xa1a2a1a3)
2
select locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3);
locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3)
0
select locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3 collate ujis_bin);
locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3 collate ujis_bin)
0
select locate('he','hello');
locate('he','hello')
1
select locate('he','hello',2);
locate('he','hello',2)
0
select locate('lo','hello',2);
locate('lo','hello',2)
4
select locate('HE','hello');
locate('HE','hello')
1
select locate('HE','hello',2);
locate('HE','hello',2)
0
select locate('LO','hello',2);
locate('LO','hello',2)
4
select locate('HE','hello' collate ujis_bin);
locate('HE','hello' collate ujis_bin)
0
select locate('HE','hello' collate ujis_bin,2);
locate('HE','hello' collate ujis_bin,2)
0
select locate('LO','hello' collate ujis_bin,2);
locate('LO','hello' collate ujis_bin,2)
0
select locate(_ujis 0xa1a3,_ujis 0xa1a2a1a3);
locate(_ujis 0xa1a3,_ujis 0xa1a2a1a3)
2
select 0xa1a2a1a3 like concat(_binary'%',0xa2a1,_binary'%');
0xa1a2a1a3 like concat(_binary'%',0xa2a1,_binary'%')
1
select _ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%');
_ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%')
0
select _ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%') collate ujis_bin;
_ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%') collate ujis_bin
0
select 'a' like 'a';
'a' like 'a'
1
select 'A' like 'a';
'A' like 'a'
1
select 'A' like 'a' collate ujis_bin;
'A' like 'a' collate ujis_bin
0
set @ujis1= _ujis     0x8EA18EA28EA38EA48EA58EA68EA78EA88EA98EAA8EAB8EAC8EAD8EAE8EAF;
set @ujis2= _ujis 0x8EB08EB18EB28EB38EB48EB58EB68EB78EB88EB98EBA8EBB8EBC8EBD8EBE8EBF;
set @ujis3= _ujis 0x8EC08EC18EC28EC38EC48EC58EC68EC78EC88EC98ECA8ECB8ECC8ECD8ECE8ECF;
set @ujis4= _ujis 0x8ED08ED18ED28ED38ED48ED58ED68ED78ED88ED98EDA8EDB8EDC8EDD8EDE8EDF;
select hex(@utf81:= CONVERT(@ujis1 USING utf8));
hex(@utf81:= CONVERT(@ujis1 USING utf8))
EFBDA1EFBDA2EFBDA3EFBDA4EFBDA5EFBDA6EFBDA7EFBDA8EFBDA9EFBDAAEFBDABEFBDACEFBDADEFBDAEEFBDAF
select hex(@utf82:= CONVERT(@ujis2 USING utf8));
hex(@utf82:= CONVERT(@ujis2 USING utf8))
EFBDB0EFBDB1EFBDB2EFBDB3EFBDB4EFBDB5EFBDB6EFBDB7EFBDB8EFBDB9EFBDBAEFBDBBEFBDBCEFBDBDEFBDBEEFBDBF
select hex(@utf83:= CONVERT(@ujis3 USING utf8));
hex(@utf83:= CONVERT(@ujis3 USING utf8))
EFBE80EFBE81EFBE82EFBE83EFBE84EFBE85EFBE86EFBE87EFBE88EFBE89EFBE8AEFBE8BEFBE8CEFBE8DEFBE8EEFBE8F
select hex(@utf84:= CONVERT(@ujis4 USING utf8));
hex(@utf84:= CONVERT(@ujis4 USING utf8))
EFBE90EFBE91EFBE92EFBE93EFBE94EFBE95EFBE96EFBE97EFBE98EFBE99EFBE9AEFBE9BEFBE9CEFBE9DEFBE9EEFBE9F
select @ujis1 = CONVERT(@utf81 USING ujis);
@ujis1 = CONVERT(@utf81 USING ujis)
1
select @ujis2 = CONVERT(@utf82 USING ujis);
@ujis2 = CONVERT(@utf82 USING ujis)
1
select @ujis3 = CONVERT(@utf83 USING ujis);
@ujis3 = CONVERT(@utf83 USING ujis)
1
select @ujis4 = CONVERT(@utf84 USING ujis);
@ujis4 = CONVERT(@utf84 USING ujis)
1
drop table if exists t1;
Warnings:
Note	1051	Unknown table 't1'
create table t1 (c1 varchar(8)) default character set 'ujis';
insert into t1 values (0xA4A2),(0xA2A2),(0xA4A2);
select c1 as 'no index' from t1 where c1 like cast(concat(0xA4A2, '%') as char character set ujis);
no index
あ
あ
create index idx_c1 on t1(c1);
select c1 as 'using index' from t1 where c1 like cast(concat(0xA4A2, '%') as char character set ujis);
using index
あ
あ
select c1 as 'no index' from t1 where c1 like cast(concat('%',0xA4A2, '%') as char character set ujis);
no index
あ
あ
drop table t1;
CREATE TABLE t1 (
a char(1) NOT NULL default '',
b enum('あ','い') default NULL
) CHARACTER SET ujis;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` char(1) NOT NULL default '',
  `b` enum('あ','い') default NULL
) ENGINE=MyISAM DEFAULT CHARSET=ujis
SHOW COLUMNS FROM t1;
Field	Type	Null	Key	Default	Extra
a	char(1)	NO			
b	enum('あ','い')	YES		NULL	
DROP TABLE t1;
CREATE TABLE t1
(
a INTEGER NOT NULL,
b VARCHAR(50) NOT NULL DEFAULT '',
PRIMARY KEY  (a),
KEY b (b(10))
) TYPE=InnoDB CHARACTER SET 'ujis' COLLATE 'ujis_japanese_ci';
INSERT INTO t1 (a, b) VALUES (0, 'aaabbbcccddd');
INSERT INTO t1 (a, b) VALUES (1, 'eeefffggghhh');
INSERT INTO t1 (a, b) VALUES (2, 'iiijjjkkkl');
SELECT t1.* FROM t1 WHERE b='aaabbbcccddd' ORDER BY a;
a	b
0	aaabbbcccddd
SELECT t1.* FROM t1 WHERE b='eeefffggghhh' ORDER BY a;
a	b
1	eeefffggghhh
SELECT t1.* FROM t1 WHERE b='iiijjjkkkl'   ORDER BY a;
a	b
2	iiijjjkkkl
DROP TABLE t1;
CREATE TABLE t1
(
a INTEGER NOT NULL,
b VARCHAR(50) NOT NULL DEFAULT '',
PRIMARY KEY  (a),
KEY b (b(10))
) TYPE=MyISAM CHARACTER SET 'ujis' COLLATE 'ujis_japanese_ci';
INSERT INTO t1 (a, b) VALUES (0, 'aaabbbcccddd');
INSERT INTO t1 (a, b) VALUES (1, 'eeefffggghhh');
INSERT INTO t1 (a, b) VALUES (2, 'iiijjjkkkl');
SELECT t1.* FROM t1 WHERE b='aaabbbcccddd' ORDER BY a;
a	b
0	aaabbbcccddd
SELECT t1.* FROM t1 WHERE b='eeefffggghhh' ORDER BY a;
a	b
1	eeefffggghhh
SELECT t1.* FROM t1 WHERE b='iiijjjkkkl'   ORDER BY a;
a	b
2	iiijjjkkkl
DROP TABLE t1;
DROP TABLE IF EXISTS t1;
Warnings:
Note	1051	Unknown table 't1'
CREATE TABLE t1(c char(1)) character set ujis;
INSERT INTO t1 VALUES(0xA2AF);
INSERT INTO t1 VALUES(0xA2B0);
INSERT INTO t1 VALUES(0xA2B1);
INSERT INTO t1 VALUES(0xA2B2);
INSERT INTO t1 VALUES(0xA2B3);
INSERT INTO t1 VALUES(0xA2B4);
INSERT INTO t1 VALUES(0xA2B5);
INSERT INTO t1 VALUES(0xA2B6);
INSERT INTO t1 VALUES(0xA2B7);
INSERT INTO t1 VALUES(0xA2B8);
INSERT INTO t1 VALUES(0xA2B9);
INSERT INTO t1 VALUES(0xA2C2);
INSERT INTO t1 VALUES(0xA2C3);
INSERT INTO t1 VALUES(0xA2C4);
INSERT INTO t1 VALUES(0xA2C5);
INSERT INTO t1 VALUES(0xA2C6);
INSERT INTO t1 VALUES(0xA2C7);
INSERT INTO t1 VALUES(0xA2C8);
INSERT INTO t1 VALUES(0xA2C9);
INSERT INTO t1 VALUES(0xA2D1);
INSERT INTO t1 VALUES(0xA2D2);
INSERT INTO t1 VALUES(0xA2D3);
INSERT INTO t1 VALUES(0xA2D4);
INSERT INTO t1 VALUES(0xA2D5);
INSERT INTO t1 VALUES(0xA2D6);
INSERT INTO t1 VALUES(0xA2D7);
INSERT INTO t1 VALUES(0xA2D8);
INSERT INTO t1 VALUES(0xA2D9);
INSERT INTO t1 VALUES(0xA2DA);
INSERT INTO t1 VALUES(0xA2DB);
INSERT INTO t1 VALUES(0xA2EB);
INSERT INTO t1 VALUES(0xA2EC);
INSERT INTO t1 VALUES(0xA2ED);
INSERT INTO t1 VALUES(0xA2EE);
INSERT INTO t1 VALUES(0xA2EF);
INSERT INTO t1 VALUES(0xA2F0);
INSERT INTO t1 VALUES(0xA2F1);
INSERT INTO t1 VALUES(0xA2FA);
INSERT INTO t1 VALUES(0xA2FB);
INSERT INTO t1 VALUES(0xA2FC);
INSERT INTO t1 VALUES(0xA2FD);
INSERT INTO t1 VALUES(0xA3A1);
INSERT INTO t1 VALUES(0xA3A2);
INSERT INTO t1 VALUES(0xA3A3);
INSERT INTO t1 VALUES(0xA3A4);
INSERT INTO t1 VALUES(0xA3A5);
INSERT INTO t1 VALUES(0xA3A6);
INSERT INTO t1 VALUES(0xA3A7);
INSERT INTO t1 VALUES(0xA3A8);
INSERT INTO t1 VALUES(0xA3A9);
INSERT INTO t1 VALUES(0xA3AA);
INSERT INTO t1 VALUES(0xA3AB);
INSERT INTO t1 VALUES(0xA3AC);
INSERT INTO t1 VALUES(0xA3AD);
INSERT INTO t1 VALUES(0xA3AE);
INSERT INTO t1 VALUES(0xA3AF);
INSERT INTO t1 VALUES(0xA3BA);
INSERT INTO t1 VALUES(0xA3BB);
INSERT INTO t1 VALUES(0xA3BC);
INSERT INTO t1 VALUES(0xA3BD);
INSERT INTO t1 VALUES(0xA3BE);
INSERT INTO t1 VALUES(0xA3BF);
INSERT INTO t1 VALUES(0xA3C0);
INSERT INTO t1 VALUES(0xA3DB);
INSERT INTO t1 VALUES(0xA3DC);
INSERT INTO t1 VALUES(0xA3DD);
INSERT INTO t1 VALUES(0xA3DE);
INSERT INTO t1 VALUES(0xA3DF);
INSERT INTO t1 VALUES(0xA3E0);
INSERT INTO t1 VALUES(0xA3FB);
INSERT INTO t1 VALUES(0xA3FC);
INSERT INTO t1 VALUES(0xA3FD);
INSERT INTO t1 VALUES(0xA3FE);
INSERT INTO t1 VALUES(0xA4F4);
INSERT INTO t1 VALUES(0xA4F5);
INSERT INTO t1 VALUES(0xA4F6);
INSERT INTO t1 VALUES(0xA4F7);
INSERT INTO t1 VALUES(0xA4F8);
INSERT INTO t1 VALUES(0xA4F9);
INSERT INTO t1 VALUES(0xA4FA);
INSERT INTO t1 VALUES(0xA4FB);
INSERT INTO t1 VALUES(0xA4FC);
INSERT INTO t1 VALUES(0xA4FD);
INSERT INTO t1 VALUES(0xA4FE);
INSERT INTO t1 VALUES(0xA5F7);
INSERT INTO t1 VALUES(0xA5F8);
INSERT INTO t1 VALUES(0xA5F9);
INSERT INTO t1 VALUES(0xA5FA);
INSERT INTO t1 VALUES(0xA5FB);
INSERT INTO t1 VALUES(0xA5FC);
INSERT INTO t1 VALUES(0xA5FD);
INSERT INTO t1 VALUES(0xA5FE);
INSERT INTO t1 VALUES(0xA6B9);
INSERT INTO t1 VALUES(0xA6BA);
INSERT INTO t1 VALUES(0xA6BB);
INSERT INTO t1 VALUES(0xA6BC);
INSERT INTO t1 VALUES(0xA6BD);
INSERT INTO t1 VALUES(0xA6BE);
INSERT INTO t1 VALUES(0xA6BF);
INSERT INTO t1 VALUES(0xA6C0);
INSERT INTO t1 VALUES(0xA6D9);
INSERT INTO t1 VALUES(0xA6DA);
INSERT INTO t1 VALUES(0xA6DB);
INSERT INTO t1 VALUES(0xA6DC);
INSERT INTO t1 VALUES(0xA6DD);
INSERT INTO t1 VALUES(0xA6DE);
INSERT INTO t1 VALUES(0xA6DF);
INSERT INTO t1 VALUES(0xA6E0);
INSERT INTO t1 VALUES(0xA6E1);
INSERT INTO t1 VALUES(0xA6E2);
INSERT INTO t1 VALUES(0xA6E3);
INSERT INTO t1 VALUES(0xA6E4);
INSERT INTO t1 VALUES(0xA6E5);
INSERT INTO t1 VALUES(0xA6E6);
INSERT INTO t1 VALUES(0xA6E7);
INSERT INTO t1 VALUES(0xA6E8);
INSERT INTO t1 VALUES(0xA6E9);
INSERT INTO t1 VALUES(0xA6EA);
INSERT INTO t1 VALUES(0xA6EB);
INSERT INTO t1 VALUES(0xA6EC);
INSERT INTO t1 VALUES(0xA6ED);
INSERT INTO t1 VALUES(0xA6EE);
INSERT INTO t1 VALUES(0xA6EF);
INSERT INTO t1 VALUES(0xA6F0);
INSERT INTO t1 VALUES(0xA6F1);
INSERT INTO t1 VALUES(0xA6F2);
INSERT INTO t1 VALUES(0xA6F3);
INSERT INTO t1 VALUES(0xA6F4);
INSERT INTO t1 VALUES(0xA6F5);
INSERT INTO t1 VALUES(0xA6F6);
INSERT INTO t1 VALUES(0xA6F7);
INSERT INTO t1 VALUES(0xA6F8);
INSERT INTO t1 VALUES(0xA6F9);
INSERT INTO t1 VALUES(0xA6FA);
INSERT INTO t1 VALUES(0xA6FB);
INSERT INTO t1 VALUES(0xA6FC);
INSERT INTO t1 VALUES(0xA6FD);
INSERT INTO t1 VALUES(0xA6FE);
INSERT INTO t1 VALUES(0xA7C2);
INSERT INTO t1 VALUES(0xA7C3);
INSERT INTO t1 VALUES(0xA7C4);
INSERT INTO t1 VALUES(0xA7C5);
INSERT INTO t1 VALUES(0xA7C6);
INSERT INTO t1 VALUES(0xA7C7);
INSERT INTO t1 VALUES(0xA7C8);
INSERT INTO t1 VALUES(0xA7C9);
INSERT INTO t1 VALUES(0xA7CA);
INSERT INTO t1 VALUES(0xA7CB);
INSERT INTO t1 VALUES(0xA7CC);
INSERT INTO t1 VALUES(0xA7CD);
INSERT INTO t1 VALUES(0xA7CE);
INSERT INTO t1 VALUES(0xA7CF);
INSERT INTO t1 VALUES(0xA7D0);
INSERT INTO t1 VALUES(0xA7F2);
INSERT INTO t1 VALUES(0xA7F3);
INSERT INTO t1 VALUES(0xA7F4);
INSERT INTO t1 VALUES(0xA7F5);
INSERT INTO t1 VALUES(0xA7F6);
INSERT INTO t1 VALUES(0xA7F7);
INSERT INTO t1 VALUES(0xA7F8);
INSERT INTO t1 VALUES(0xA7F9);
INSERT INTO t1 VALUES(0xA7FA);
INSERT INTO t1 VALUES(0xA7FB);
INSERT INTO t1 VALUES(0xA7FC);
INSERT INTO t1 VALUES(0xA7FD);
INSERT INTO t1 VALUES(0xA7FE);
INSERT INTO t1 VALUES(0xA8C1);
INSERT INTO t1 VALUES(0xA8C2);
INSERT INTO t1 VALUES(0xA8C3);
INSERT INTO t1 VALUES(0xA8C4);
INSERT INTO t1 VALUES(0xA8C5);
INSERT INTO t1 VALUES(0xA8C6);
INSERT INTO t1 VALUES(0xA8C7);
INSERT INTO t1 VALUES(0xA8C8);
INSERT INTO t1 VALUES(0xA8C9);
INSERT INTO t1 VALUES(0xA8CA);
INSERT INTO t1 VALUES(0xA8CB);
INSERT INTO t1 VALUES(0xA8CC);
INSERT INTO t1 VALUES(0xA8CD);
INSERT INTO t1 VALUES(0xA8CE);
INSERT INTO t1 VALUES(0xA8CF);
INSERT INTO t1 VALUES(0xA8D0);
INSERT INTO t1 VALUES(0xA8D1);
INSERT INTO t1 VALUES(0xA8D2);
INSERT INTO t1 VALUES(0xA8D3);
INSERT INTO t1 VALUES(0xA8D4);
INSERT INTO t1 VALUES(0xA8D5);
INSERT INTO t1 VALUES(0xA8D6);
INSERT INTO t1 VALUES(0xA8D7);
INSERT INTO t1 VALUES(0xA8D8);
INSERT INTO t1 VALUES(0xA8D9);
INSERT INTO t1 VALUES(0xA8DA);
INSERT INTO t1 VALUES(0xA8DB);
INSERT INTO t1 VALUES(0xA8DC);
INSERT INTO t1 VALUES(0xA8DD);
INSERT INTO t1 VALUES(0xA8DE);
INSERT INTO t1 VALUES(0xA8DF);
INSERT INTO t1 VALUES(0xA8E0);
INSERT INTO t1 VALUES(0xA8E1);
INSERT INTO t1 VALUES(0xA8E2);
INSERT INTO t1 VALUES(0xA8E3);
INSERT INTO t1 VALUES(0xA8E4);
INSERT INTO t1 VALUES(0xA8E5);
INSERT INTO t1 VALUES(0xA8E6);
INSERT INTO t1 VALUES(0xA8E7);
INSERT INTO t1 VALUES(0xA8E8);
INSERT INTO t1 VALUES(0xA8E9);
INSERT INTO t1 VALUES(0xA8EA);
INSERT INTO t1 VALUES(0xA8EB);
INSERT INTO t1 VALUES(0xA8EC);
INSERT INTO t1 VALUES(0xA8ED);
INSERT INTO t1 VALUES(0xA8EE);
INSERT INTO t1 VALUES(0xA8EF);
INSERT INTO t1 VALUES(0xA8F0);
INSERT INTO t1 VALUES(0xA8F1);
INSERT INTO t1 VALUES(0xA8F2);
INSERT INTO t1 VALUES(0xA8F3);
INSERT INTO t1 VALUES(0xA8F4);
INSERT INTO t1 VALUES(0xA8F5);
INSERT INTO t1 VALUES(0xA8F6);
INSERT INTO t1 VALUES(0xA8F7);
INSERT INTO t1 VALUES(0xA8F8);
INSERT INTO t1 VALUES(0xA8F9);
INSERT INTO t1 VALUES(0xA8FA);
INSERT INTO t1 VALUES(0xA8FB);
INSERT INTO t1 VALUES(0xA8FC);
INSERT INTO t1 VALUES(0xA8FD);
INSERT INTO t1 VALUES(0xA8FE);
INSERT INTO t1 VALUES(0xA9A1);
INSERT INTO t1 VALUES(0xA9A2);
INSERT INTO t1 VALUES(0xA9A3);
INSERT INTO t1 VALUES(0xA9A4);
INSERT INTO t1 VALUES(0xA9A5);
INSERT INTO t1 VALUES(0xA9A6);
INSERT INTO t1 VALUES(0xA9A7);
INSERT INTO t1 VALUES(0xA9A8);
INSERT INTO t1 VALUES(0xA9A9);
INSERT INTO t1 VALUES(0xA9AA);
INSERT INTO t1 VALUES(0xA9AB);
INSERT INTO t1 VALUES(0xA9AC);
INSERT INTO t1 VALUES(0xA9AD);
INSERT INTO t1 VALUES(0xA9AE);
INSERT INTO t1 VALUES(0xA9AF);
INSERT INTO t1 VALUES(0xA9B0);
INSERT INTO t1 VALUES(0xA9B1);
INSERT INTO t1 VALUES(0xA9B2);
INSERT INTO t1 VALUES(0xA9B3);
INSERT INTO t1 VALUES(0xA9B4);
INSERT INTO t1 VALUES(0xA9B5);
INSERT INTO t1 VALUES(0xA9B6);
INSERT INTO t1 VALUES(0xA9B7);
INSERT INTO t1 VALUES(0xA9B8);
INSERT INTO t1 VALUES(0xA9B9);
INSERT INTO t1 VALUES(0xA9BA);
INSERT INTO t1 VALUES(0xA9BB);
INSERT INTO t1 VALUES(0xA9BC);
INSERT INTO t1 VALUES(0xA9BD);
INSERT INTO t1 VALUES(0xA9BE);
INSERT INTO t1 VALUES(0xA9BF);
INSERT INTO t1 VALUES(0xA9C0);
INSERT INTO t1 VALUES(0xA9C1);
INSERT INTO t1 VALUES(0xA9C2);
INSERT INTO t1 VALUES(0xA9C3);
INSERT INTO t1 VALUES(0xA9C4);
INSERT INTO t1 VALUES(0xA9C5);
INSERT INTO t1 VALUES(0xA9C6);
INSERT INTO t1 VALUES(0xA9C7);
INSERT INTO t1 VALUES(0xA9C8);
INSERT INTO t1 VALUES(0xA9C9);
INSERT INTO t1 VALUES(0xA9CA);
INSERT INTO t1 VALUES(0xA9CB);
INSERT INTO t1 VALUES(0xA9CC);
INSERT INTO t1 VALUES(0xA9CD);
INSERT INTO t1 VALUES(0xA9CE);
INSERT INTO t1 VALUES(0xA9CF);
INSERT INTO t1 VALUES(0xA9D0);
INSERT INTO t1 VALUES(0xA9D1);
INSERT INTO t1 VALUES(0xA9D2);
INSERT INTO t1 VALUES(0xA9D3);
INSERT INTO t1 VALUES(0xA9D4);
INSERT INTO t1 VALUES(0xA9D5);
INSERT INTO t1 VALUES(0xA9D6);
INSERT INTO t1 VALUES(0xA9D7);
INSERT INTO t1 VALUES(0xA9D8);
INSERT INTO t1 VALUES(0xA9D9);
INSERT INTO t1 VALUES(0xA9DA);
INSERT INTO t1 VALUES(0xA9DB);
INSERT INTO t1 VALUES(0xA9DC);
INSERT INTO t1 VALUES(0xA9DD);
INSERT INTO t1 VALUES(0xA9DE);
INSERT INTO t1 VALUES(0xA9DF);
INSERT INTO t1 VALUES(0xA9E0);
INSERT INTO t1 VALUES(0xA9E1);
INSERT INTO t1 VALUES(0xA9E2);
INSERT INTO t1 VALUES(0xA9E3);
INSERT INTO t1 VALUES(0xA9E4);
INSERT INTO t1 VALUES(0xA9E5);
INSERT INTO t1 VALUES(0xA9E6);
INSERT INTO t1 VALUES(0xA9E7);
INSERT INTO t1 VALUES(0xA9E8);
INSERT INTO t1 VALUES(0xA9E9);
INSERT INTO t1 VALUES(0xA9EA);
INSERT INTO t1 VALUES(0xA9EB);
INSERT INTO t1 VALUES(0xA9EC);
INSERT INTO t1 VALUES(0xA9ED);
INSERT INTO t1 VALUES(0xA9EE);
INSERT INTO t1 VALUES(0xA9EF);
INSERT INTO t1 VALUES(0xA9F0);
INSERT INTO t1 VALUES(0xA9F1);
INSERT INTO t1 VALUES(0xA9F2);
INSERT INTO t1 VALUES(0xA9F3);
INSERT INTO t1 VALUES(0xA9F4);
INSERT INTO t1 VALUES(0xA9F5);
INSERT INTO t1 VALUES(0xA9F6);
INSERT INTO t1 VALUES(0xA9F7);
INSERT INTO t1 VALUES(0xA9F8);
INSERT INTO t1 VALUES(0xA9F9);
INSERT INTO t1 VALUES(0xA9FA);
INSERT INTO t1 VALUES(0xA9FB);
INSERT INTO t1 VALUES(0xA9FC);
INSERT INTO t1 VALUES(0xA9FD);
INSERT INTO t1 VALUES(0xA9FE);
INSERT INTO t1 VALUES(0xAAA1);
INSERT INTO t1 VALUES(0xAAA2);
INSERT INTO t1 VALUES(0xAAA3);
INSERT INTO t1 VALUES(0xAAA4);
INSERT INTO t1 VALUES(0xAAA5);
INSERT INTO t1 VALUES(0xAAA6);
INSERT INTO t1 VALUES(0xAAA7);
INSERT INTO t1 VALUES(0xAAA8);
INSERT INTO t1 VALUES(0xAAA9);
INSERT INTO t1 VALUES(0xAAAA);
INSERT INTO t1 VALUES(0xAAAB);
INSERT INTO t1 VALUES(0xAAAC);
INSERT INTO t1 VALUES(0xAAAD);
INSERT INTO t1 VALUES(0xAAAE);
INSERT INTO t1 VALUES(0xAAAF);
INSERT INTO t1 VALUES(0xAAB0);
INSERT INTO t1 VALUES(0xAAB1);
INSERT INTO t1 VALUES(0xAAB2);
INSERT INTO t1 VALUES(0xAAB3);
INSERT INTO t1 VALUES(0xAAB4);
INSERT INTO t1 VALUES(0xAAB5);
INSERT INTO t1 VALUES(0xAAB6);
INSERT INTO t1 VALUES(0xAAB7);
INSERT INTO t1 VALUES(0xAAB8);
INSERT INTO t1 VALUES(0xAAB9);
INSERT INTO t1 VALUES(0xAABA);
INSERT INTO t1 VALUES(0xAABB);
INSERT INTO t1 VALUES(0xAABC);
INSERT INTO t1 VALUES(0xAABD);
INSERT INTO t1 VALUES(0xAABE);
INSERT INTO t1 VALUES(0xAABF);
INSERT INTO t1 VALUES(0xAAC0);
INSERT INTO t1 VALUES(0xAAC1);
INSERT INTO t1 VALUES(0xAAC2);
INSERT INTO t1 VALUES(0xAAC3);
INSERT INTO t1 VALUES(0xAAC4);
INSERT INTO t1 VALUES(0xAAC5);
INSERT INTO t1 VALUES(0xAAC6);
INSERT INTO t1 VALUES(0xAAC7);
INSERT INTO t1 VALUES(0xAAC8);
INSERT INTO t1 VALUES(0xAAC9);
INSERT INTO t1 VALUES(0xAACA);
INSERT INTO t1 VALUES(0xAACB);
INSERT INTO t1 VALUES(0xAACC);
INSERT INTO t1 VALUES(0xAACD);
INSERT INTO t1 VALUES(0xAACE);
INSERT INTO t1 VALUES(0xAACF);
INSERT INTO t1 VALUES(0xAAD0);
INSERT INTO t1 VALUES(0xAAD1);
INSERT INTO t1 VALUES(0xAAD2);
INSERT INTO t1 VALUES(0xAAD3);
INSERT INTO t1 VALUES(0xAAD4);
INSERT INTO t1 VALUES(0xAAD5);
INSERT INTO t1 VALUES(0xAAD6);
INSERT INTO t1 VALUES(0xAAD7);
INSERT INTO t1 VALUES(0xAAD8);
INSERT INTO t1 VALUES(0xAAD9);
INSERT INTO t1 VALUES(0xAADA);
INSERT INTO t1 VALUES(0xAADB);
INSERT INTO t1 VALUES(0xAADC);
INSERT INTO t1 VALUES(0xAADD);
INSERT INTO t1 VALUES(0xAADE);
INSERT INTO t1 VALUES(0xAADF);
INSERT INTO t1 VALUES(0xAAE0);
INSERT INTO t1 VALUES(0xAAE1);
INSERT INTO t1 VALUES(0xAAE2);
INSERT INTO t1 VALUES(0xAAE3);
INSERT INTO t1 VALUES(0xAAE4);
INSERT INTO t1 VALUES(0xAAE5);
INSERT INTO t1 VALUES(0xAAE6);
INSERT INTO t1 VALUES(0xAAE7);
INSERT INTO t1 VALUES(0xAAE8);
INSERT INTO t1 VALUES(0xAAE9);
INSERT INTO t1 VALUES(0xAAEA);
INSERT INTO t1 VALUES(0xAAEB);
INSERT INTO t1 VALUES(0xAAEC);
INSERT INTO t1 VALUES(0xAAED);
INSERT INTO t1 VALUES(0xAAEE);
INSERT INTO t1 VALUES(0xAAEF);
INSERT INTO t1 VALUES(0xAAF0);
INSERT INTO t1 VALUES(0xAAF1);
INSERT INTO t1 VALUES(0xAAF2);
INSERT INTO t1 VALUES(0xAAF3);
INSERT INTO t1 VALUES(0xAAF4);
INSERT INTO t1 VALUES(0xAAF5);
INSERT INTO t1 VALUES(0xAAF6);
INSERT INTO t1 VALUES(0xAAF7);
INSERT INTO t1 VALUES(0xAAF8);
INSERT INTO t1 VALUES(0xAAF9);
INSERT INTO t1 VALUES(0xAAFA);
INSERT INTO t1 VALUES(0xAAFB);
INSERT INTO t1 VALUES(0xAAFC);
INSERT INTO t1 VALUES(0xAAFD);
INSERT INTO t1 VALUES(0xAAFE);
INSERT INTO t1 VALUES(0xABA1);
INSERT INTO t1 VALUES(0xABA2);
INSERT INTO t1 VALUES(0xABA3);
INSERT INTO t1 VALUES(0xABA4);
INSERT INTO t1 VALUES(0xABA5);
INSERT INTO t1 VALUES(0xABA6);
INSERT INTO t1 VALUES(0xABA7);
INSERT INTO t1 VALUES(0xABA8);
INSERT INTO t1 VALUES(0xABA9);
INSERT INTO t1 VALUES(0xABAA);
INSERT INTO t1 VALUES(0xABAB);
INSERT INTO t1 VALUES(0xABAC);
INSERT INTO t1 VALUES(0xABAD);
INSERT INTO t1 VALUES(0xABAE);
INSERT INTO t1 VALUES(0xABAF);
INSERT INTO t1 VALUES(0xABB0);
INSERT INTO t1 VALUES(0xABB1);
INSERT INTO t1 VALUES(0xABB2);
INSERT INTO t1 VALUES(0xABB3);
INSERT INTO t1 VALUES(0xABB4);
INSERT INTO t1 VALUES(0xABB5);
INSERT INTO t1 VALUES(0xABB6);
INSERT INTO t1 VALUES(0xABB7);
INSERT INTO t1 VALUES(0xABB8);
INSERT INTO t1 VALUES(0xABB9);
INSERT INTO t1 VALUES(0xABBA);
INSERT INTO t1 VALUES(0xABBB);
INSERT INTO t1 VALUES(0xABBC);
INSERT INTO t1 VALUES(0xABBD);
INSERT INTO t1 VALUES(0xABBE);
INSERT INTO t1 VALUES(0xABBF);
INSERT INTO t1 VALUES(0xABC0);
INSERT INTO t1 VALUES(0xABC1);
INSERT INTO t1 VALUES(0xABC2);
INSERT INTO t1 VALUES(0xABC3);
INSERT INTO t1 VALUES(0xABC4);
INSERT INTO t1 VALUES(0xABC5);
INSERT INTO t1 VALUES(0xABC6);
INSERT INTO t1 VALUES(0xABC7);
INSERT INTO t1 VALUES(0xABC8);
INSERT INTO t1 VALUES(0xABC9);
INSERT INTO t1 VALUES(0xABCA);
INSERT INTO t1 VALUES(0xABCB);
INSERT INTO t1 VALUES(0xABCC);
INSERT INTO t1 VALUES(0xABCD);
INSERT INTO t1 VALUES(0xABCE);
INSERT INTO t1 VALUES(0xABCF);
INSERT INTO t1 VALUES(0xABD0);
INSERT INTO t1 VALUES(0xABD1);
INSERT INTO t1 VALUES(0xABD2);
INSERT INTO t1 VALUES(0xABD3);
INSERT INTO t1 VALUES(0xABD4);
INSERT INTO t1 VALUES(0xABD5);
INSERT INTO t1 VALUES(0xABD6);
INSERT INTO t1 VALUES(0xABD7);
INSERT INTO t1 VALUES(0xABD8);
INSERT INTO t1 VALUES(0xABD9);
INSERT INTO t1 VALUES(0xABDA);
INSERT INTO t1 VALUES(0xABDB);
INSERT INTO t1 VALUES(0xABDC);
INSERT INTO t1 VALUES(0xABDD);
INSERT INTO t1 VALUES(0xABDE);
INSERT INTO t1 VALUES(0xABDF);
INSERT INTO t1 VALUES(0xABE0);
INSERT INTO t1 VALUES(0xABE1);
INSERT INTO t1 VALUES(0xABE2);
INSERT INTO t1 VALUES(0xABE3);
INSERT INTO t1 VALUES(0xABE4);
INSERT INTO t1 VALUES(0xABE5);
INSERT INTO t1 VALUES(0xABE6);
INSERT INTO t1 VALUES(0xABE7);
INSERT INTO t1 VALUES(0xABE8);
INSERT INTO t1 VALUES(0xABE9);
INSERT INTO t1 VALUES(0xABEA);
INSERT INTO t1 VALUES(0xABEB);
INSERT INTO t1 VALUES(0xABEC);
INSERT INTO t1 VALUES(0xABED);
INSERT INTO t1 VALUES(0xABEE);
INSERT INTO t1 VALUES(0xABEF);
INSERT INTO t1 VALUES(0xABF0);
INSERT INTO t1 VALUES(0xABF1);
INSERT INTO t1 VALUES(0xABF2);
INSERT INTO t1 VALUES(0xABF3);
INSERT INTO t1 VALUES(0xABF4);
INSERT INTO t1 VALUES(0xABF5);
INSERT INTO t1 VALUES(0xABF6);
INSERT INTO t1 VALUES(0xABF7);
INSERT INTO t1 VALUES(0xABF8);
INSERT INTO t1 VALUES(0xABF9);
INSERT INTO t1 VALUES(0xABFA);
INSERT INTO t1 VALUES(0xABFB);
INSERT INTO t1 VALUES(0xABFC);
INSERT INTO t1 VALUES(0xABFD);
INSERT INTO t1 VALUES(0xABFE);
INSERT INTO t1 VALUES(0xACA1);
INSERT INTO t1 VALUES(0xACA2);
INSERT INTO t1 VALUES(0xACA3);
INSERT INTO t1 VALUES(0xACA4);
INSERT INTO t1 VALUES(0xACA5);
INSERT INTO t1 VALUES(0xACA6);
INSERT INTO t1 VALUES(0xACA7);
INSERT INTO t1 VALUES(0xACA8);
INSERT INTO t1 VALUES(0xACA9);
INSERT INTO t1 VALUES(0xACAA);
INSERT INTO t1 VALUES(0xACAB);
INSERT INTO t1 VALUES(0xACAC);
INSERT INTO t1 VALUES(0xACAD);
INSERT INTO t1 VALUES(0xACAE);
INSERT INTO t1 VALUES(0xACAF);
INSERT INTO t1 VALUES(0xACB0);
INSERT INTO t1 VALUES(0xACB1);
INSERT INTO t1 VALUES(0xACB2);
INSERT INTO t1 VALUES(0xACB3);
INSERT INTO t1 VALUES(0xACB4);
INSERT INTO t1 VALUES(0xACB5);
INSERT INTO t1 VALUES(0xACB6);
INSERT INTO t1 VALUES(0xACB7);
INSERT INTO t1 VALUES(0xACB8);
INSERT INTO t1 VALUES(0xACB9);
INSERT INTO t1 VALUES(0xACBA);
INSERT INTO t1 VALUES(0xACBB);
INSERT INTO t1 VALUES(0xACBC);
INSERT INTO t1 VALUES(0xACBD);
INSERT INTO t1 VALUES(0xACBE);
INSERT INTO t1 VALUES(0xACBF);
INSERT INTO t1 VALUES(0xACC0);
INSERT INTO t1 VALUES(0xACC1);
INSERT INTO t1 VALUES(0xACC2);
INSERT INTO t1 VALUES(0xACC3);
INSERT INTO t1 VALUES(0xACC4);
INSERT INTO t1 VALUES(0xACC5);
INSERT INTO t1 VALUES(0xACC6);
INSERT INTO t1 VALUES(0xACC7);
INSERT INTO t1 VALUES(0xACC8);
INSERT INTO t1 VALUES(0xACC9);
INSERT INTO t1 VALUES(0xACCA);
INSERT INTO t1 VALUES(0xACCB);
INSERT INTO t1 VALUES(0xACCC);
INSERT INTO t1 VALUES(0xACCD);
INSERT INTO t1 VALUES(0xACCE);
INSERT INTO t1 VALUES(0xACCF);
INSERT INTO t1 VALUES(0xACD0);
INSERT INTO t1 VALUES(0xACD1);
INSERT INTO t1 VALUES(0xACD2);
INSERT INTO t1 VALUES(0xACD3);
INSERT INTO t1 VALUES(0xACD4);
INSERT INTO t1 VALUES(0xACD5);
INSERT INTO t1 VALUES(0xACD6);
INSERT INTO t1 VALUES(0xACD7);
INSERT INTO t1 VALUES(0xACD8);
INSERT INTO t1 VALUES(0xACD9);
INSERT INTO t1 VALUES(0xACDA);
INSERT INTO t1 VALUES(0xACDB);
INSERT INTO t1 VALUES(0xACDC);
INSERT INTO t1 VALUES(0xACDD);
INSERT INTO t1 VALUES(0xACDE);
INSERT INTO t1 VALUES(0xACDF);
INSERT INTO t1 VALUES(0xACE0);
INSERT INTO t1 VALUES(0xACE1);
INSERT INTO t1 VALUES(0xACE2);
INSERT INTO t1 VALUES(0xACE3);
INSERT INTO t1 VALUES(0xACE4);
INSERT INTO t1 VALUES(0xACE5);
INSERT INTO t1 VALUES(0xACE6);
INSERT INTO t1 VALUES(0xACE7);
INSERT INTO t1 VALUES(0xACE8);
INSERT INTO t1 VALUES(0xACE9);
INSERT INTO t1 VALUES(0xACEA);
INSERT INTO t1 VALUES(0xACEB);
INSERT INTO t1 VALUES(0xACEC);
INSERT INTO t1 VALUES(0xACED);
INSERT INTO t1 VALUES(0xACEE);
INSERT INTO t1 VALUES(0xACEF);
INSERT INTO t1 VALUES(0xACF0);
INSERT INTO t1 VALUES(0xACF1);
INSERT INTO t1 VALUES(0xACF2);
INSERT INTO t1 VALUES(0xACF3);
INSERT INTO t1 VALUES(0xACF4);
INSERT INTO t1 VALUES(0xACF5);
INSERT INTO t1 VALUES(0xACF6);
INSERT INTO t1 VALUES(0xACF7);
INSERT INTO t1 VALUES(0xACF8);
INSERT INTO t1 VALUES(0xACF9);
INSERT INTO t1 VALUES(0xACFA);
INSERT INTO t1 VALUES(0xACFB);
INSERT INTO t1 VALUES(0xACFC);
INSERT INTO t1 VALUES(0xACFD);
INSERT INTO t1 VALUES(0xACFE);
INSERT INTO t1 VALUES(0xADA1);
INSERT INTO t1 VALUES(0xADA2);
INSERT INTO t1 VALUES(0xADA3);
INSERT INTO t1 VALUES(0xADA4);
INSERT INTO t1 VALUES(0xADA5);
INSERT INTO t1 VALUES(0xADA6);