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)) ) ENGINE=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)) ) ENGINE=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); INSERT INTO t1 VALUES(0xADA7); INSERT INTO t1 VALUES(0xADA8); INSERT INTO t1 VALUES(0xADA9); INSERT INTO t1 VALUES(0xADAA); INSERT INTO t1 VALUES(0xADAB); INSERT INTO t1 VALUES(0xADAC); INSERT INTO t1 VALUES(0xADAD); INSERT INTO t1 VALUES(0xADAE); INSERT INTO t1 VALUES(0xADAF); INSERT INTO t1 VALUES(0xADB0); INSERT INTO t1 VALUES(0xADB1); INSERT INTO t1 VALUES(0xADB2); INSERT INTO t1 VALUES(0xADB3); INSERT INTO t1 VALUES(0xADB4); INSERT INTO t1 VALUES(0xADB5); INSERT INTO t1 VALUES(0xADB6); INSERT INTO t1 VALUES(0xADB7); INSERT INTO t1 VALUES(0xADB8); INSERT INTO t1 VALUES(0xADB9); INSERT INTO t1 VALUES(0xADBA); INSERT INTO t1 VALUES(0xADBB); INSERT INTO t1 VALUES(0xADBC); INSERT INTO t1 VALUES(0xADBD); INSERT INTO t1 VALUES(0xADBE); INSERT INTO t1 VALUES(0xADBF); INSERT INTO t1 VALUES(0xADC0); INSERT INTO t1 VALUES(0xADC1); INSERT INTO t1 VALUES(0xADC2); INSERT INTO t1 VALUES(0xADC3); INSERT INTO t1 VALUES(0xADC4); INSERT INTO t1 VALUES(0xADC5); INSERT INTO t1 VALUES(0xADC6); INSERT INTO t1 VALUES(0xADC7); INSERT INTO t1 VALUES(0xADC8); INSERT INTO t1 VALUES(0xADC9); INSERT INTO t1 VALUES(0xADCA); INSERT INTO t1 VALUES(0xADCB); INSERT INTO t1 VALUES(0xADCC); INSERT INTO t1 VALUES(0xADCD); INSERT INTO t1 VALUES(0xADCE); INSERT INTO t1 VALUES(0xADCF); INSERT INTO t1 VALUES(0xADD0); INSERT INTO t1 VALUES(0xADD1); INSERT INTO t1 VALUES(0xADD2); INSERT INTO t1 VALUES(0xADD3); INSERT INTO t1 VALUES(0xADD4); INSERT INTO t1 VALUES(0xADD5); INSERT INTO t1 VALUES(0xADD6); INSERT INTO t1 VALUES(0xADD7); INSERT INTO t1 VALUES(0xADD8); INSERT INTO t1 VALUES(0xADD9); INSERT INTO t1 VALUES(0xADDA); INSERT INTO t1 VALUES(0xADDB); INSERT INTO t1 VALUES(0xADDC); INSERT INTO t1 VALUES(0xADDD); INSERT INTO t1 VALUES(0xADDE); INSERT INTO t1 VALUES(0xADDF); INSERT INTO t1 VALUES(0xADE0); INSERT INTO t1 VALUES(0xADE1); INSERT INTO t1 VALUES(0xADE2); INSERT INTO t1 VALUES(0xADE3); INSERT INTO t1 VALUES(0xADE4); INSERT INTO t1 VALUES(0xADE5); INSERT INTO t1 VALUES(0xADE6); INSERT INTO t1 VALUES(0xADE7); INSERT INTO t1 VALUES(0xADE8); INSERT INTO t1 VALUES(0xADE9); INSERT INTO t1 VALUES(0xADEA); INSERT INTO t1 VALUES(0xADEB); INSERT INTO t1 VALUES(0xADEC); INSERT INTO t1 VALUES(0xADED); INSERT INTO t1 VALUES(0xADEE); INSERT INTO t1 VALUES(0xADEF); INSERT INTO t1 VALUES(0xADF0); INSERT INTO t1 VALUES(0xADF1); INSERT INTO t1 VALUES(0xADF2); INSERT INTO t1 VALUES(0xADF3); INSERT INTO t1 VALUES(0xADF4); INSERT INTO t1 VALUES(0xADF5); INSERT INTO t1 VALUES(0xADF6); INSERT INTO t1 VALUES(0xADF7); INSERT INTO t1 VALUES(0xADF8); INSERT INTO t1 VALUES(0xADF9); INSERT INTO t1 VALUES(0xADFA); INSERT INTO t1 VALUES(0xADFB); INSERT INTO t1 VALUES(0xADFC); INSERT INTO t1 VALUES(0xADFD); INSERT INTO t1 VALUES(0xADFE); INSERT INTO t1 VALUES(0xAEA1); INSERT INTO t1 VALUES(0xAEA2); INSERT INTO t1 VALUES(0xAEA3); INSERT INTO t1 VALUES(0xAEA4); INSERT INTO t1 VALUES(0xAEA5); INSERT INTO t1 VALUES(0xAEA6); INSERT INTO t1 VALUES(0xAEA7); INSERT INTO t1 VALUES(0xAEA8); INSERT INTO t1 VALUES(0xAEA9); INSERT INTO t1 VALUES(0xAEAA); INSERT INTO t1 VALUES(0xAEAB); INSERT INTO t1 VALUES(0xAEAC); INSERT INTO t1 VALUES(0xAEAD); INSERT INTO t1 VALUES(0xAEAE); INSERT INTO t1 VALUES(0xAEAF); INSERT INTO t1 VALUES(0xAEB0); INSERT INTO t1 VALUES(0xAEB1); INSERT INTO t1 VALUES(0xAEB2); INSERT INTO t1 VALUES(0xAEB3); INSERT INTO t1 VALUES(0xAEB4); INSERT INTO t1 VALUES(0xAEB5); INSERT INTO t1 VALUES(0xAEB6); INSERT INTO t1 VALUES(0xAEB7); INSERT INTO t1 VALUES(0xAEB8); INSERT INTO t1 VALUES(0xAEB9); INSERT INTO t1 VALUES(0xAEBA); INSERT INTO t1 VALUES(0xAEBB); INSERT INTO t1 VALUES(0xAEBC); INSERT INTO t1 VALUES(0xAEBD); INSERT INTO t1 VALUES(0xAEBE); INSERT INTO t1 VALUES(0xAEBF); INSERT INTO t1 VALUES(0xAEC0); INSERT INTO t1 VALUES(0xAEC1); INSERT INTO t1 VALUES(0xAEC2); INSERT INTO t1 VALUES(0xAEC3); INSERT INTO t1 VALUES(0xAEC4); INSERT INTO t1 VALUES(0xAEC5); INSERT INTO t1 VALUES(0xAEC6); INSERT INTO t1 VALUES(0xAEC7); INSERT INTO t1 VALUES(0xAEC8); INSERT INTO t1 VALUES(0xAEC9); INSERT INTO t1 VALUES(0xAECA); INSERT INTO t1 VALUES(0xAECB); INSERT INTO t1 VALUES(0xAECC); INSERT INTO t1 VALUES(0xAECD); INSERT INTO t1 VALUES(0xAECE); INSERT INTO t1 VALUES(0xAECF); INSERT INTO t1 VALUES(0xAED0); INSERT INTO t1 VALUES(0xAED1); INSERT INTO t1 VALUES(0xAED2); INSERT INTO t1 VALUES(0xAED3); INSERT INTO t1 VALUES(0xAED4); INSERT INTO t1 VALUES(0xAED5); INSERT INTO t1 VALUES(0xAED6); INSERT INTO t1 VALUES(0xAED7); INSERT INTO t1 VALUES(0xAED8); INSERT INTO t1 VALUES(0xAED9); INSERT INTO t1 VALUES(0xAEDA); INSERT INTO t1 VALUES(0xAEDB); INSERT INTO t1 VALUES(0xAEDC); INSERT INTO t1 VALUES(0xAEDD); INSERT INTO t1 VALUES(0xAEDE); INSERT INTO t1 VALUES(0xAEDF); INSERT INTO t1 VALUES(0xAEE0); INSERT INTO t1 VALUES(0xAEE1); INSERT INTO t1 VALUES(0xAEE2); INSERT INTO t1 VALUES(0xAEE3); INSERT INTO t1 VALUES(0xAEE4); INSERT INTO t1 VALUES(0xAEE5); INSERT INTO t1 VALUES(0xAEE6); INSERT INTO t1 VALUES(0xAEE7); INSERT INTO t1 VALUES(0xAEE8); INSERT INTO t1 VALUES(0xAEE9); INSERT INTO t1 VALUES(0xAEEA); INSERT INTO t1 VALUES(0xAEEB); INSERT INTO t1 VALUES(0xAEEC); INSERT INTO t1 VALUES(0xAEED); INSERT INTO t1 VALUES(0xAEEE); INSERT INTO t1 VALUES(0xAEEF); INSERT INTO t1 VALUES(0xAEF0); INSERT INTO t1 VALUES(0xAEF1); INSERT INTO t1 VALUES(0xAEF2); INSERT INTO t1 VALUES(0xAEF3); INSERT INTO t1 VALUES(0xAEF4); INSERT INTO t1 VALUES(0xAEF5); INSERT INTO t1 VALUES(0xAEF6); INSERT INTO t1 VALUES(0xAEF7); INSERT INTO t1 VALUES(0xAEF8); INSERT INTO t1 VALUES(0xAEF9); INSERT INTO t1 VALUES(0xAEFA); INSERT INTO t1 VALUES(0xAEFB); INSERT INTO t1 VALUES(0xAEFC); INSERT INTO t1 VALUES(0xAEFD); INSERT INTO t1 VALUES(0xAEFE); INSERT INTO t1 VALUES(0xAFA1); INSERT INTO t1 VALUES(0xAFA2); INSERT INTO t1 VALUES(0xAFA3); INSERT INTO t1 VALUES(0xAFA4); INSERT INTO t1 VALUES(0xAFA5); INSERT INTO t1 VALUES(0xAFA6); INSERT INTO t1 VALUES(0xAFA7); INSERT INTO t1 VALUES(0xAFA8); INSERT INTO t1 VALUES(0xAFA9); INSERT INTO t1 VALUES(0xAFAA); INSERT INTO t1 VALUES(0xAFAB); INSERT INTO t1 VALUES(0xAFAC); INSERT INTO t1 VALUES(0xAFAD); INSERT INTO t1 VALUES(0xAFAE); INSERT INTO t1 VALUES(0xAFAF); INSERT INTO t1 VALUES(0xAFB0); INSERT INTO t1 VALUES(0xAFB1); INSERT INTO t1 VALUES(0xAFB2); INSERT INTO t1 VALUES(0xAFB3); INSERT INTO t1 VALUES(0xAFB4); INSERT INTO t1 VALUES(0xAFB5); INSERT INTO t1 VALUES(0xAFB6); INSERT INTO t1 VALUES(0xAFB7); INSERT INTO t1 VALUES(0xAFB8); INSERT INTO t1 VALUES(0xAFB9); INSERT INTO t1 VALUES(0xAFBA); INSERT INTO t1 VALUES(0xAFBB); INSERT INTO t1 VALUES(0xAFBC); INSERT INTO t1 VALUES(0xAFBD); INSERT INTO t1 VALUES(0xAFBE); INSERT INTO t1 VALUES(0xAFBF); INSERT INTO t1 VALUES(0xAFC0); INSERT INTO t1 VALUES(0xAFC1); INSERT INTO t1 VALUES(0xAFC2); INSERT INTO t1 VALUES(0xAFC3); INSERT INTO t1 VALUES(0xAFC4); INSERT INTO t1 VALUES(0xAFC5); INSERT INTO t1 VALUES(0xAFC6); INSERT INTO t1 VALUES(0xAFC7); INSERT INTO t1 VALUES(0xAFC8); INSERT INTO t1 VALUES(0xAFC9); INSERT INTO t1 VALUES(0xAFCA); INSERT INTO t1 VALUES(0xAFCB); INSERT INTO t1 VALUES(0xAFCC); INSERT INTO t1 VALUES(0xAFCD); INSERT INTO t1 VALUES(0xAFCE); INSERT INTO t1 VALUES(0xAFCF); INSERT INTO t1 VALUES(0xAFD0); INSERT INTO t1 VALUES(0xAFD1); INSERT INTO t1 VALUES(0xAFD2); INSERT INTO t1 VALUES(0xAFD3); INSERT INTO t1 VALUES(0xAFD4); INSERT INTO t1 VALUES(0xAFD5); INSERT INTO t1 VALUES(0xAFD6); INSERT INTO t1 VALUES(0xAFD7); INSERT INTO t1 VALUES(0xAFD8); INSERT INTO t1 VALUES(0xAFD9); INSERT INTO t1 VALUES(0xAFDA); INSERT INTO t1 VALUES(0xAFDB); INSERT INTO t1 VALUES(0xAFDC); INSERT INTO t1 VALUES(0xAFDD); INSERT INTO t1 VALUES(0xAFDE); INSERT INTO t1 VALUES(0xAFDF); INSERT INTO t1 VALUES(0xAFE0); INSERT INTO t1 VALUES(0xAFE1); INSERT INTO t1 VALUES(0xAFE2); INSERT INTO t1 VALUES(0xAFE3); INSERT INTO t1 VALUES(0xAFE4); INSERT INTO t1 VALUES(0xAFE5); INSERT INTO t1 VALUES(0xAFE6); INSERT INTO t1 VALUES(0xAFE7); INSERT INTO t1 VALUES(0xAFE8); INSERT INTO t1 VALUES(0xAFE9); INSERT INTO t1 VALUES(0xAFEA); INSERT INTO t1 VALUES(0xAFEB); INSERT INTO t1 VALUES(0xAFEC); INSERT INTO t1 VALUES(0xAFED); INSERT INTO t1 VALUES(0xAFEE); INSERT INTO t1 VALUES(0xAFEF); INSERT INTO t1 VALUES(0xAFF0); INSERT INTO t1 VALUES(0xAFF1); INSERT INTO t1 VALUES(0xAFF2); INSERT INTO t1 VALUES(0xAFF3); INSERT INTO t1 VALUES(0xAFF4); INSERT INTO t1 VALUES(0xAFF5); INSERT INTO t1 VALUES(0xAFF6); INSERT INTO t1 VALUES(0xAFF7); INSERT INTO t1 VALUES(0xAFF8); INSERT INTO t1 VALUES(0xAFF9); INSERT INTO t1 VALUES(0xAFFA); INSERT INTO t1 VALUES(0xAFFB); INSERT INTO t1 VALUES(0xAFFC); INSERT INTO t1 VALUES(0xAFFD); INSERT INTO t1 VALUES(0xAFFE); INSERT INTO t1 VALUES(0xCFD4); INSERT INTO t1 VALUES(0xCFD5); INSERT INTO t1 VALUES(0xCFD6); INSERT INTO t1 VALUES(0xCFD7); INSERT INTO t1 VALUES(0xCFD8); INSERT INTO t1 VALUES(0xCFD9); INSERT INTO t1 VALUES(0xCFDA); INSERT INTO t1 VALUES(0xCFDB); INSERT INTO t1 VALUES(0xCFDC); INSERT INTO t1 VALUES(0xCFDD); INSERT INTO t1 VALUES(0xCFDE); INSERT INTO t1 VALUES(0xCFDF); INSERT INTO t1 VALUES(0xCFE0); INSERT INTO t1 VALUES(0xCFE1); INSERT INTO t1 VALUES(0xCFE2); INSERT INTO t1 VALUES(0xCFE3); INSERT INTO t1 VALUES(0xCFE4); INSERT INTO t1 VALUES(0xCFE5); INSERT INTO t1 VALUES(0xCFE6); INSERT INTO t1 VALUES(0xCFE7); INSERT INTO t1 VALUES(0xCFE8); INSERT INTO t1 VALUES(0xCFE9); INSERT INTO t1 VALUES(0xCFEA); INSERT INTO t1 VALUES(0xCFEB); INSERT INTO t1 VALUES(0xCFEC); INSERT INTO t1 VALUES(0xCFED); INSERT INTO t1 VALUES(0xCFEE); INSERT INTO t1 VALUES(0xCFEF); INSERT INTO t1 VALUES(0xCFF0); INSERT INTO t1 VALUES(0xCFF1); INSERT INTO t1 VALUES(0xCFF2); INSERT INTO t1 VALUES(0xCFF3); INSERT INTO t1 VALUES(0xCFF4); INSERT INTO t1 VALUES(0xCFF5); INSERT INTO t1 VALUES(0xCFF6); INSERT INTO t1 VALUES(0xCFF7); INSERT INTO t1 VALUES(0xCFF8); INSERT INTO t1 VALUES(0xCFF9); INSERT INTO t1 VALUES(0xCFFA); INSERT INTO t1 VALUES(0xCFFB); INSERT INTO t1 VALUES(0xCFFC); INSERT INTO t1 VALUES(0xCFFD); INSERT INTO t1 VALUES(0xCFFE); INSERT INTO t1 VALUES(0xF4A7); INSERT INTO t1 VALUES(0xF4A8); INSERT INTO t1 VALUES(0xF4A9); INSERT INTO t1 VALUES(0xF4AA); INSERT INTO t1 VALUES(0xF4AB); INSERT INTO t1 VALUES(0xF4AC); INSERT INTO t1 VALUES(0xF4AD); INSERT INTO t1 VALUES(0xF4AE); INSERT INTO t1 VALUES(0xF4AF); INSERT INTO t1 VALUES(0xF4B0); INSERT INTO t1 VALUES(0xF4B1); INSERT INTO t1 VALUES(0xF4B2); INSERT INTO t1 VALUES(0xF4B3); INSERT INTO t1 VALUES(0xF4B4); INSERT INTO t1 VALUES(0xF4B5); INSERT INTO t1 VALUES(0xF4B6); INSERT INTO t1 VALUES(0xF4B7); INSERT INTO t1 VALUES(0xF4B8); INSERT INTO t1 VALUES(0xF4B9); INSERT INTO t1 VALUES(0xF4BA); INSERT INTO t1 VALUES(0xF4BB); INSERT INTO t1 VALUES(0xF4BC); INSERT INTO t1 VALUES(0xF4BD); INSERT INTO t1 VALUES(0xF4BE); INSERT INTO t1 VALUES(0xF4BF); INSERT INTO t1 VALUES(0xF4C0); INSERT INTO t1 VALUES(0xF4C1); INSERT INTO t1 VALUES(0xF4C2); INSERT INTO t1 VALUES(0xF4C3); INSERT INTO t1 VALUES(0xF4C4); INSERT INTO t1 VALUES(0xF4C5); INSERT INTO t1 VALUES(0xF4C6); INSERT INTO t1 VALUES(0xF4C7); INSERT INTO t1 VALUES(0xF4C8); INSERT INTO t1 VALUES(0xF4C9); INSERT INTO t1 VALUES(0xF4CA); INSERT INTO t1 VALUES(0xF4CB); INSERT INTO t1 VALUES(0xF4CC); INSERT INTO t1 VALUES(0xF4CD); INSERT INTO t1 VALUES(0xF4CE); INSERT INTO t1 VALUES(0xF4CF); INSERT INTO t1 VALUES(0xF4D0); INSERT INTO t1 VALUES(0xF4D1); INSERT INTO t1 VALUES(0xF4D2); INSERT INTO t1 VALUES(0xF4D3); INSERT INTO t1 VALUES(0xF4D4); INSERT INTO t1 VALUES(0xF4D5); INSERT INTO t1 VALUES(0xF4D6); INSERT INTO t1 VALUES(0xF4D7); INSERT INTO t1 VALUES(0xF4D8); INSERT INTO t1 VALUES(0xF4D9); INSERT INTO t1 VALUES(0xF4DA); INSERT INTO t1 VALUES(0xF4DB); INSERT INTO t1 VALUES(0xF4DC); INSERT INTO t1 VALUES(0xF4DD); INSERT INTO t1 VALUES(0xF4DE); INSERT INTO t1 VALUES(0xF4DF); INSERT INTO t1 VALUES(0xF4E0); INSERT INTO t1 VALUES(0xF4E1); INSERT INTO t1 VALUES(0xF4E2); INSERT INTO t1 VALUES(0xF4E3); INSERT INTO t1 VALUES(0xF4E4); INSERT INTO t1 VALUES(0xF4E5); INSERT INTO t1 VALUES(0xF4E6); INSERT INTO t1 VALUES(0xF4E7); INSERT INTO t1 VALUES(0xF4E8); INSERT INTO t1 VALUES(0xF4E9); INSERT INTO t1 VALUES(0xF4EA); INSERT INTO t1 VALUES(0xF4EB); INSERT INTO t1 VALUES(0xF4EC); INSERT INTO t1 VALUES(0xF4ED); INSERT INTO t1 VALUES(0xF4EE); INSERT INTO t1 VALUES(0xF4EF); INSERT INTO t1 VALUES(0xF4F0); INSERT INTO t1 VALUES(0xF4F1); INSERT INTO t1 VALUES(0xF4F2); INSERT INTO t1 VALUES(0xF4F3); INSERT INTO t1 VALUES(0xF4F4); INSERT INTO t1 VALUES(0xF4F5); INSERT INTO t1 VALUES(0xF4F6); INSERT INTO t1 VALUES(0xF4F7); INSERT INTO t1 VALUES(0xF4F8); INSERT INTO t1 VALUES(0xF4F9); INSERT INTO t1 VALUES(0xF4FA); INSERT INTO t1 VALUES(0xF4FB); INSERT INTO t1 VALUES(0xF4FC); INSERT INTO t1 VALUES(0xF4FD); INSERT INTO t1 VALUES(0xF4FE); SELECT HEX(c) FROM t1 ORDER BY BINARY c; HEX(c) A2AF A2B0 A2B1 A2B2 A2B3 A2B4 A2B5 A2B6 A2B7 A2B8 A2B9 A2C2 A2C3 A2C4 A2C5 A2C6 A2C7 A2C8 A2C9 A2D1 A2D2 A2D3 A2D4 A2D5 A2D6 A2D7 A2D8 A2D9 A2DA A2DB A2EB A2EC A2ED A2EE A2EF A2F0 A2F1 A2FA A2FB A2FC A2FD A3A1 A3A2 A3A3 A3A4 A3A5 A3A6 A3A7 A3A8 A3A9 A3AA A3AB A3AC A3AD A3AE A3AF A3BA A3BB A3BC A3BD A3BE A3BF A3C0 A3DB A3DC A3DD A3DE A3DF A3E0 A3FB A3FC A3FD A3FE A4F4 A4F5 A4F6 A4F7 A4F8 A4F9 A4FA A4FB A4FC A4FD A4FE A5F7 A5F8 A5F9 A5FA A5FB A5FC A5FD A5FE A6B9 A6BA A6BB A6BC A6BD A6BE A6BF A6C0 A6D9 A6DA A6DB A6DC A6DD A6DE A6DF A6E0 A6E1 A6E2 A6E3 A6E4 A6E5 A6E6 A6E7 A6E8 A6E9 A6EA A6EB A6EC A6ED A6EE A6EF A6F0 A6F1 A6F2 A6F3 A6F4 A6F5 A6F6 A6F7 A6F8 A6F9 A6FA A6FB A6FC A6FD A6FE A7C2 A7C3 A7C4 A7C5 A7C6 A7C7 A7C8 A7C9 A7CA A7CB A7CC A7CD A7CE A7CF A7D0 A7F2 A7F3 A7F4 A7F5 A7F6 A7F7 A7F8 A7F9 A7FA A7FB A7FC A7FD A7FE A8C1 A8C2 A8C3 A8C4 A8C5 A8C6 A8C7 A8C8 A8C9 A8CA A8CB A8CC A8CD A8CE A8CF A8D0 A8D1 A8D2 A8D3 A8D4 A8D5 A8D6 A8D7 A8D8 A8D9 A8DA A8DB A8DC A8DD A8DE A8DF A8E0 A8E1 A8E2 A8E3 A8E4 A8E5 A8E6 A8E7 A8E8 A8E9 A8EA A8EB A8EC A8ED A8EE A8EF A8F0 A8F1 A8F2 A8F3 A8F4 A8F5 A8F6 A8F7 A8F8 A8F9 A8FA A8FB A8FC A8FD A8FE A9A1 A9A2 A9A3 A9A4 A9A5 A9A6 A9A7 A9A8 A9A9 A9AA A9AB A9AC A9AD A9AE A9AF A9B0 A9B1 A9B2 A9B3 A9B4 A9B5 A9B6 A9B7 A9B8 A9B9 A9BA A9BB A9BC A9BD A9BE A9BF A9C0 A9C1 A9C2 A9C3 A9C4 A9C5 A9C6 A9C7 A9C8 A9C9 A9CA A9CB A9CC A9CD A9CE A9CF A9D0 A9D1 A9D2 A9D3 A9D4 A9D5 A9D6 A9D7 A9D8 A9D9 A9DA A9DB A9DC A9DD A9DE A9DF A9E0 A9E1 A9E2 A9E3 A9E4 A9E5 A9E6 A9E7 A9E8 A9E9 A9EA A9EB A9EC A9ED A9EE A9EF A9F0 A9F1 A9F2 A9F3 A9F4 A9F5 A9F6 A9F7 A9F8 A9F9 A9FA A9FB A9FC A9FD A9FE AAA1 AAA2 AAA3 AAA4 AAA5 AAA6 AAA7 AAA8 AAA9 AAAA AAAB AAAC AAAD AAAE AAAF AAB0 AAB1 AAB2 AAB3 AAB4 AAB5 AAB6 AAB7 AAB8 AAB9 AABA AABB AABC AABD AABE AABF AAC0 AAC1 AAC2 AAC3 AAC4 AAC5 AAC6 AAC7 AAC8 AAC9 AACA AACB AACC AACD AACE AACF AAD0 AAD1 AAD2 AAD3 AAD4 AAD5 AAD6 AAD7 AAD8 AAD9 AADA AADB AADC AADD AADE AADF AAE0 AAE1 AAE2 AAE3 AAE4 AAE5 AAE6 AAE7 AAE8 AAE9 AAEA AAEB AAEC AAED AAEE AAEF AAF0 AAF1 AAF2 AAF3 AAF4 AAF5 AAF6 AAF7 AAF8 AAF9 AAFA AAFB AAFC AAFD AAFE ABA1 ABA2 ABA3 ABA4 ABA5 ABA6 ABA7 ABA8 ABA9 ABAA ABAB ABAC ABAD ABAE ABAF ABB0 ABB1 ABB2 ABB3 ABB4 ABB5 ABB6 ABB7 ABB8 ABB9 ABBA ABBB ABBC ABBD ABBE ABBF ABC0 ABC1 ABC2 ABC3 ABC4 ABC5 ABC6 ABC7 ABC8 ABC9 ABCA ABCB ABCC ABCD ABCE ABCF ABD0 ABD1 ABD2 ABD3 ABD4 ABD5 ABD6 ABD7 ABD8 ABD9 ABDA ABDB ABDC ABDD ABDE ABDF ABE0 ABE1 ABE2 ABE3 ABE4 ABE5 ABE6 ABE7 ABE8 ABE9 ABEA ABEB ABEC ABED ABEE ABEF ABF0 ABF1 ABF2 ABF3 ABF4 ABF5 ABF6 ABF7 ABF8 ABF9 ABFA ABFB ABFC ABFD ABFE ACA1 ACA2 ACA3 ACA4 ACA5 ACA6 ACA7 ACA8 ACA9 ACAA ACAB ACAC ACAD ACAE ACAF ACB0 ACB1 ACB2 ACB3 ACB4 ACB5 ACB6 ACB7 ACB8 ACB9 ACBA ACBB ACBC ACBD ACBE ACBF ACC0 ACC1 ACC2 ACC3 ACC4 ACC5 ACC6 ACC7 ACC8 ACC9 ACCA ACCB ACCC ACCD ACCE ACCF ACD0 ACD1 ACD2 ACD3 ACD4 ACD5 ACD6 ACD7 ACD8 ACD9 ACDA ACDB ACDC ACDD ACDE ACDF ACE0 ACE1 ACE2 ACE3 ACE4 ACE5 ACE6 ACE7 ACE8 ACE9 ACEA ACEB ACEC ACED ACEE ACEF ACF0 ACF1 ACF2 ACF3 ACF4 ACF5 ACF6 ACF7 ACF8 ACF9 ACFA ACFB ACFC ACFD ACFE ADA1 ADA2 ADA3 ADA4 ADA5 ADA6 ADA7 ADA8 ADA9 ADAA ADAB ADAC ADAD ADAE ADAF ADB0 ADB1 ADB2 ADB3 ADB4 ADB5 ADB6 ADB7 ADB8 ADB9 ADBA ADBB ADBC ADBD ADBE ADBF ADC0 ADC1 ADC2 ADC3 ADC4 ADC5 ADC6 ADC7 ADC8 ADC9 ADCA ADCB ADCC ADCD ADCE ADCF ADD0 ADD1 ADD2 ADD3 ADD4 ADD5 ADD6 ADD7 ADD8 ADD9 ADDA ADDB ADDC ADDD ADDE ADDF ADE0 ADE1 ADE2 ADE3 ADE4 ADE5 ADE6 ADE7 ADE8 ADE9 ADEA ADEB ADEC ADED ADEE ADEF ADF0 ADF1 ADF2 ADF3 ADF4 ADF5 ADF6 ADF7 ADF8 ADF9 ADFA ADFB ADFC ADFD ADFE AEA1 AEA2 AEA3 AEA4 AEA5 AEA6 AEA7 AEA8 AEA9 AEAA AEAB AEAC AEAD AEAE AEAF AEB0 AEB1 AEB2 AEB3 AEB4 AEB5 AEB6 AEB7 AEB8 AEB9 AEBA AEBB AEBC AEBD AEBE AEBF AEC0 AEC1 AEC2 AEC3 AEC4 AEC5 AEC6 AEC7 AEC8 AEC9 AECA AECB AECC AECD AECE AECF AED0 AED1 AED2 AED3 AED4 AED5 AED6 AED7 AED8 AED9 AEDA AEDB AEDC AEDD AEDE AEDF AEE0 AEE1 AEE2 AEE3 AEE4 AEE5 AEE6 AEE7 AEE8 AEE9 AEEA AEEB AEEC AEED AEEE AEEF AEF0 AEF1 AEF2 AEF3 AEF4 AEF5 AEF6 AEF7 AEF8 AEF9 AEFA AEFB AEFC AEFD AEFE AFA1 AFA2 AFA3 AFA4 AFA5 AFA6 AFA7 AFA8 AFA9 AFAA AFAB AFAC AFAD AFAE AFAF AFB0 AFB1 AFB2 AFB3 AFB4 AFB5 AFB6 AFB7 AFB8 AFB9 AFBA AFBB AFBC AFBD AFBE AFBF AFC0 AFC1 AFC2 AFC3 AFC4 AFC5 AFC6 AFC7 AFC8 AFC9 AFCA AFCB AFCC AFCD AFCE AFCF AFD0 AFD1 AFD2 AFD3 AFD4 AFD5 AFD6 AFD7 AFD8 AFD9 AFDA AFDB AFDC AFDD AFDE AFDF AFE0 AFE1 AFE2 AFE3 AFE4 AFE5 AFE6 AFE7 AFE8 AFE9 AFEA AFEB AFEC AFED AFEE AFEF AFF0 AFF1 AFF2 AFF3 AFF4 AFF5 AFF6 AFF7 AFF8 AFF9 AFFA AFFB AFFC AFFD AFFE CFD4 CFD5 CFD6 CFD7 CFD8 CFD9 CFDA CFDB CFDC CFDD CFDE CFDF CFE0 CFE1 CFE2 CFE3 CFE4 CFE5 CFE6 CFE7 CFE8 CFE9 CFEA CFEB CFEC CFED CFEE CFEF CFF0 CFF1 CFF2 CFF3 CFF4 CFF5 CFF6 CFF7 CFF8 CFF9 CFFA CFFB CFFC CFFD CFFE F4A7 F4A8 F4A9 F4AA F4AB F4AC F4AD F4AE F4AF F4B0 F4B1 F4B2 F4B3 F4B4 F4B5 F4B6 F4B7 F4B8 F4B9 F4BA F4BB F4BC F4BD F4BE F4BF F4C0 F4C1 F4C2 F4C3 F4C4 F4C5 F4C6 F4C7 F4C8 F4C9 F4CA F4CB F4CC F4CD F4CE F4CF F4D0 F4D1 F4D2 F4D3 F4D4 F4D5 F4D6 F4D7 F4D8 F4D9 F4DA F4DB F4DC F4DD F4DE F4DF F4E0 F4E1 F4E2 F4E3 F4E4 F4E5 F4E6 F4E7 F4E8 F4E9 F4EA F4EB F4EC F4ED F4EE F4EF F4F0 F4F1 F4F2 F4F3 F4F4 F4F5 F4F6 F4F7 F4F8 F4F9 F4FA F4FB F4FC F4FD F4FE DROP TABLE t1; SET collation_connection='ujis_japanese_ci'; create table t1 select repeat('a',4000) a; delete from t1; insert into t1 values ('a'), ('a '), ('a\t'); select collation(a),hex(a) from t1 order by a; collation(a) hex(a) ujis_japanese_ci 6109 ujis_japanese_ci 61 ujis_japanese_ci 6120 drop table t1; create table t1 engine=innodb select repeat('a',50) as c1; alter table t1 add index(c1(5)); insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111'); select collation(c1) from t1 limit 1; collation(c1) ujis_japanese_ci select c1 from t1 where c1 like 'abcdef%' order by c1; c1 abcdefg select c1 from t1 where c1 like 'abcde1%' order by c1; c1 abcde100 abcde110 abcde111 select c1 from t1 where c1 like 'abcde11%' order by c1; c1 abcde110 abcde111 select c1 from t1 where c1 like 'abcde111%' order by c1; c1 abcde111 drop table t1; select @@collation_connection; @@collation_connection ujis_japanese_ci create table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ; insert into t1 values('abcdef'); insert into t1 values('_bcdef'); insert into t1 values('a_cdef'); insert into t1 values('ab_def'); insert into t1 values('abc_ef'); insert into t1 values('abcd_f'); insert into t1 values('abcde_'); select c1 as c1u from t1 where c1 like 'ab\_def'; c1u ab_def select c1 as c2h from t1 where c1 like 'ab#_def' escape '#'; c2h ab_def drop table t1; CREATE TABLE t1 AS SELECT 10 AS a, REPEAT('a',20) AS b, REPEAT('a',8) AS c, REPEAT('a',8) AS d; ALTER TABLE t1 ADD PRIMARY KEY(a), ADD KEY(b); INSERT INTO t1 (a, b) VALUES (1, repeat(0xF1F2,5)); INSERT INTO t1 (a, b) VALUES (2, repeat(0xF1F2,10)); INSERT INTO t1 (a, b) VALUES (3, repeat(0xF1F2,11)); INSERT INTO t1 (a, b) VALUES (4, repeat(0xF1F2,12)); SELECT hex(concat(repeat(0xF1F2, 10), '%')); hex(concat(repeat(0xF1F2, 10), '%')) F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F225 3 rows expected SELECT a, hex(b), c FROM t1 WHERE b LIKE concat(repeat(0xF1F2,10), '%'); a hex(b) c 2 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 3 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 4 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 DROP TABLE t1; SET collation_connection='ujis_bin'; create table t1 select repeat('a',4000) a; delete from t1; insert into t1 values ('a'), ('a '), ('a\t'); select collation(a),hex(a) from t1 order by a; collation(a) hex(a) ujis_bin 6109 ujis_bin 61 ujis_bin 6120 drop table t1; create table t1 engine=innodb select repeat('a',50) as c1; alter table t1 add index(c1(5)); insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111'); select collation(c1) from t1 limit 1; collation(c1) ujis_bin select c1 from t1 where c1 like 'abcdef%' order by c1; c1 abcdefg select c1 from t1 where c1 like 'abcde1%' order by c1; c1 abcde100 abcde110 abcde111 select c1 from t1 where c1 like 'abcde11%' order by c1; c1 abcde110 abcde111 select c1 from t1 where c1 like 'abcde111%' order by c1; c1 abcde111 drop table t1; select @@collation_connection; @@collation_connection ujis_bin create table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ; insert into t1 values('abcdef'); insert into t1 values('_bcdef'); insert into t1 values('a_cdef'); insert into t1 values('ab_def'); insert into t1 values('abc_ef'); insert into t1 values('abcd_f'); insert into t1 values('abcde_'); select c1 as c1u from t1 where c1 like 'ab\_def'; c1u ab_def select c1 as c2h from t1 where c1 like 'ab#_def' escape '#'; c2h ab_def drop table t1; CREATE TABLE t1 AS SELECT 10 AS a, REPEAT('a',20) AS b, REPEAT('a',8) AS c, REPEAT('a',8) AS d; ALTER TABLE t1 ADD PRIMARY KEY(a), ADD KEY(b); INSERT INTO t1 (a, b) VALUES (1, repeat(0xF1F2,5)); INSERT INTO t1 (a, b) VALUES (2, repeat(0xF1F2,10)); INSERT INTO t1 (a, b) VALUES (3, repeat(0xF1F2,11)); INSERT INTO t1 (a, b) VALUES (4, repeat(0xF1F2,12)); SELECT hex(concat(repeat(0xF1F2, 10), '%')); hex(concat(repeat(0xF1F2, 10), '%')) F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F225 3 rows expected SELECT a, hex(b), c FROM t1 WHERE b LIKE concat(repeat(0xF1F2,10), '%'); a hex(b) c 2 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 3 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 4 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 DROP TABLE t1; select hex(convert(_ujis 0xA5FE41 using ucs2)); hex(convert(_ujis 0xA5FE41 using ucs2)) 003F0041 select hex(convert(_ujis 0x8FABF841 using ucs2)); hex(convert(_ujis 0x8FABF841 using ucs2)) 003F0041 DROP TABLE IF EXISTS t1, t2; DROP PROCEDURE IF EXISTS sp1; set names ujis; set character_set_database = ujis; set character_set_server = ujis; CREATE TABLE t1(c1 char(2)) default charset = ujis; CREATE TABLE t2(c2 char(2)) default charset = ujis; INSERT INTO t1 VALUES(_ujis 0xA4A2); CREATE PROCEDURE sp1() BEGIN DECLARE a CHAR(2) CHARSET ujis; DECLARE cur1 CURSOR FOR SELECT c1 FROM t1; OPEN cur1; FETCH cur1 INTO a; INSERT INTO t2 VALUES (a); CLOSE cur1; END| CALL sp1(); SELECT c1,c2 FROM t1,t2; c1 c2 あ あ SELECT hex(convert(_latin1 0xA4A2 using ujis)),hex(c2) FROM t1,t2; hex(convert(_latin1 0xA4A2 using ujis)) hex(c2) 8FA2F0A1F1 A4A2 DROP PROCEDURE sp1; DROP TABLE t1; DROP TABLE t2; # # Bug#57257 Replace(ExtractValue(...)) causes MySQL crash # SET NAMES utf8; SELECT CONVERT(REPLACE(EXPORT_SET('a','a','a','','a'),'00','') USING ujis); CONVERT(REPLACE(EXPORT_SET('a','a','a','','a'),'00','') USING ujis) Warnings: Warning 1292 Truncated incorrect INTEGER value: 'a' Warning 1292 Truncated incorrect INTEGER value: 'a' set names default; set character_set_database=default; set character_set_server=default;