ctype_ujis.test

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

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;
DROP TABLE t1;


SET collation_connection='ujis_japanese_ci';
-- source include/ctype_filesort.inc
-- source include/ctype_innodb_like.inc
-- source include/ctype_like_escape.inc
SET collation_connection='ujis_bin';
-- source include/ctype_filesort.inc
-- source include/ctype_innodb_like.inc
-- source include/ctype_like_escape.inc

#
# Bugs#15375: Unassigned multibyte codes are broken
# into parts when converting to Unicode.
# This query should return 0x003F0041. I.e. it should
# scan unassigned double-byte character 0xA5FE, convert
# it as QUESTION MARK 0x003F and then scan the next
# character, which is a single byte character 0x41.
#
select hex(convert(_ujis 0xA5FE41 using ucs2));
# This one should return 0x003F0041:
# scan unassigned three-byte character 0x8FABF8,
# convert it as QUESTION MARK 0x003F and then scan
# the next character, which is a single byte character 0x41.
select hex(convert(_ujis 0x8FABF841 using ucs2));

# End of 4.1 tests
--disable_warnings
DROP TABLE IF EXISTS t1, t2;
DROP PROCEDURE IF EXISTS sp1;
--enable_warnings

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);

DELIMITER |;
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|
DELIMITER ;|
CALL sp1();

#The data in t1 and t2 should be the same but different
SELECT c1,c2 FROM t1,t2;

#Since the result of hex(convert(_latin1 0xA4A2 using ujis))
#equals to hex(c2), it seems that the value which was inserted 
#by using cursor is interpreted as latin1 character set
SELECT hex(convert(_latin1 0xA4A2 using ujis)),hex(c2) FROM t1,t2;

DROP PROCEDURE sp1;
DROP TABLE t1;
DROP TABLE t2;

set names default;
set character_set_database=default;
set character_set_server=default;