ctype_ujis.test

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

-- source include/have_ujis.inc

#
# Tests with the ujis character set
#
--disable_warnings
drop table if exists t1;
--enable_warnings

set names ujis;

#
# Test problem with LEFT()
#

create table t1 (c text character set ujis);
insert into t1 values (0xa4a2),(0xa4a3);
select hex(left(c,1)) from t1 group by c;
drop table t1;

#
#
#
select locate(0xa2a1,0xa1a2a1a3);
select locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3);
select locate(_ujis 0xa2a1,_ujis 0xa1a2a1a3 collate ujis_bin);
select locate('he','hello');
select locate('he','hello',2);
select locate('lo','hello',2);
select locate('HE','hello');
select locate('HE','hello',2);
select locate('LO','hello',2);
select locate('HE','hello' collate ujis_bin);
select locate('HE','hello' collate ujis_bin,2);
select locate('LO','hello' collate ujis_bin,2);
select locate(_ujis 0xa1a3,_ujis 0xa1a2a1a3);

select 0xa1a2a1a3 like concat(_binary'%',0xa2a1,_binary'%');
select _ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%');
select _ujis 0xa1a2a1a3 like concat(_ujis'%',_ujis 0xa2a1, _ujis'%') collate ujis_bin;
select 'a' like 'a';
select 'A' like 'a';
select 'A' like 'a' collate ujis_bin;

#
# Bug 3290: Hald-width Katakana conversion problem.
# Check ujis-utf8-ujis round trip.
#
set @ujis1= _ujis     0x8EA18EA28EA38EA48EA58EA68EA78EA88EA98EAA8EAB8EAC8EAD8EAE8EAF;
set @ujis2= _ujis 0x8EB08EB18EB28EB38EB48EB58EB68EB78EB88EB98EBA8EBB8EBC8EBD8EBE8EBF;
set @ujis3= _ujis 0x8EC08EC18EC28EC38EC48EC58EC68EC78EC88EC98ECA8ECB8ECC8ECD8ECE8ECF;
set @ujis4= _ujis 0x8ED08ED18ED28ED38ED48ED58ED68ED78ED88ED98EDA8EDB8EDC8EDD8EDE8EDF;

select hex(@utf81:= CONVERT(@ujis1 USING utf8));
select hex(@utf82:= CONVERT(@ujis2 USING utf8));
select hex(@utf83:= CONVERT(@ujis3 USING utf8));
select hex(@utf84:= CONVERT(@ujis4 USING utf8));

select @ujis1 = CONVERT(@utf81 USING ujis);
select @ujis2 = CONVERT(@utf82 USING ujis);
select @ujis3 = CONVERT(@utf83 USING ujis);
select @ujis4 = CONVERT(@utf84 USING ujis);

#
# Testing with '%' and index (Bug #3438)
#

drop table if exists 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);
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);
select c1 as 'no index' from t1 where c1 like cast(concat('%',0xA4A2, '%') as char character set ujis);
drop table t1;


# Bug 2077
CREATE TABLE t1 (
  a char(1) NOT NULL default '',
  b enum('あ','い') default NULL
) CHARACTER SET ujis;
SHOW CREATE TABLE t1;
SHOW COLUMNS FROM t1;
DROP TABLE t1;

#
# Bug #6345 Unexpected behaviour with partial indices
#
--disable_warnings
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';
--enable_warnings
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;
SELECT t1.* FROM t1 WHERE b='eeefffggghhh' ORDER BY a;
SELECT t1.* FROM t1 WHERE b='iiijjjkkkl'   ORDER BY a;
DROP TABLE t1;
--disable_warnings
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';
--enable_warnings
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;
SELECT t1.* FROM t1 WHERE b='eeefffggghhh' ORDER BY a;
SELECT t1.* FROM t1 WHERE b='iiijjjkkkl'   ORDER BY a;
DROP TABLE t1;

DROP TABLE IF EXISTS 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);