--character_set sjis --disable_warnings drop table if exists `�s�P`; drop table if exists `�s�Q`; drop table if exists `�s�R`; drop table if exists `�s�S`; drop table if exists `�s�T`; drop table if exists `�s�U`; drop table if exists `�s�V`; drop table if exists `�s�W`; drop table if exists `�s�X`; drop table if exists `�s�P�O`; drop table if exists `�s�P�P`; drop table if exists `�s�P�Q`; --enable_warnings # # Test LIKE pattern matching using Japanese characters in sjis encoding # SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `�s�P` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Q` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�R` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�S` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�T` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�U` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�V` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�W` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�X` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�O` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; CREATE TABLE `�s�P�P` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; CREATE TABLE `�s�P�Q` (`�b�P` char(20), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb; #Load the following data in each table # jisx0201 hankaku-katakana data # jisx0208 data LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `�s�P`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `�s�Q`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `�s�R`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `�s�S`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `�s�T`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `�s�U`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `�s�V`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `�s�W`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `�s�X`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `�s�P�O`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `�s�P�P`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `�s�P�Q`; #InnoDB SELECT * FROM `�s�P` WHERE `�b�P` LIKE ' %'; SELECT * FROM `�s�P` WHERE `�b�P` LIKE '% %'; SELECT * FROM `�s�P` WHERE `�b�P` LIKE '% '; SELECT * FROM `�s�P` WHERE `�b�P` LIKE '�%'; SELECT * FROM `�s�P` WHERE `�b�P` LIKE '%��%'; SELECT * FROM `�s�P` WHERE `�b�P` LIKE '%�'; SELECT * FROM `�s�P` WHERE `�b�P` LIKE '����������������%'; SELECT * FROM `�s�P` WHERE `�b�P` LIKE '%����������������%'; SELECT * FROM `�s�P` WHERE `�b�P` LIKE '%����������������'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '�@%'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '%�@%'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '%�@'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '��%'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '%��%'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '%��'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '�E��������������������������������������%'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '%�E��������������������������������������%'; SELECT * FROM `�s�Q` WHERE `�b�P` LIKE '%�E��������������������������������������'; SELECT * FROM `�s�R` WHERE `�b�P` LIKE '�\%'; SELECT * FROM `�s�R` WHERE `�b�P` LIKE '%�\%'; SELECT * FROM `�s�R` WHERE `�b�P` LIKE '%�\'; SELECT * FROM `�s�R` WHERE `�b�P` LIKE '�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\%'; SELECT * FROM `�s�R` WHERE `�b�P` LIKE '%�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\%'; SELECT * FROM `�s�R` WHERE `�b�P` LIKE '%�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\'; #MyISAM SELECT * FROM `�s�S` WHERE `�b�P` LIKE ' %'; SELECT * FROM `�s�S` WHERE `�b�P` LIKE '% %'; SELECT * FROM `�s�S` WHERE `�b�P` LIKE '% '; SELECT * FROM `�s�S` WHERE `�b�P` LIKE '�%'; SELECT * FROM `�s�S` WHERE `�b�P` LIKE '%��%'; SELECT * FROM `�s�S` WHERE `�b�P` LIKE '%�'; SELECT * FROM `�s�S` WHERE `�b�P` LIKE '����������������%'; SELECT * FROM `�s�S` WHERE `�b�P` LIKE '%����������������%'; SELECT * FROM `�s�S` WHERE `�b�P` LIKE '%����������������'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '�@%'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '%�@%'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '%�@'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '��%'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '%��%'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '%��'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '�E��������������������������������������%'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '%�E��������������������������������������%'; SELECT * FROM `�s�T` WHERE `�b�P` LIKE '%�E��������������������������������������'; SELECT * FROM `�s�U` WHERE `�b�P` LIKE '�\%'; SELECT * FROM `�s�U` WHERE `�b�P` LIKE '%�\%'; SELECT * FROM `�s�U` WHERE `�b�P` LIKE '%�\'; SELECT * FROM `�s�U` WHERE `�b�P` LIKE '�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\%'; SELECT * FROM `�s�U` WHERE `�b�P` LIKE '%�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\%'; SELECT * FROM `�s�U` WHERE `�b�P` LIKE '%�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\'; #Heap SELECT * FROM `�s�V` WHERE `�b�P` LIKE ' %'; SELECT * FROM `�s�V` WHERE `�b�P` LIKE '% %'; SELECT * FROM `�s�V` WHERE `�b�P` LIKE '% '; SELECT * FROM `�s�V` WHERE `�b�P` LIKE '�%'; SELECT * FROM `�s�V` WHERE `�b�P` LIKE '%��%'; SELECT * FROM `�s�V` WHERE `�b�P` LIKE '%�'; SELECT * FROM `�s�V` WHERE `�b�P` LIKE '����������������%'; SELECT * FROM `�s�V` WHERE `�b�P` LIKE '%����������������%'; SELECT * FROM `�s�V` WHERE `�b�P` LIKE '%����������������'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '�@%'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '%�@%'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '%�@'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '��%'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '%��%'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '%��'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '�E��������������������������������������%'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '%�E��������������������������������������%'; SELECT * FROM `�s�W` WHERE `�b�P` LIKE '%�E��������������������������������������'; SELECT * FROM `�s�X` WHERE `�b�P` LIKE '�\%'; SELECT * FROM `�s�X` WHERE `�b�P` LIKE '%�\%'; SELECT * FROM `�s�X` WHERE `�b�P` LIKE '%�\'; SELECT * FROM `�s�X` WHERE `�b�P` LIKE '�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\%'; SELECT * FROM `�s�X` WHERE `�b�P` LIKE '%�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\%'; SELECT * FROM `�s�X` WHERE `�b�P` LIKE '%�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\'; #BDB SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE ' %'; SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE '% %'; SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE '% '; SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE '�%'; SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE '%��%'; SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE '%�'; #SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE '����������������%'; #SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE '%����������������%'; SELECT * FROM `�s�P�O` WHERE `�b�P` LIKE '%����������������'; SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '�@%'; SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '%�@%'; SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '%�@'; SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '��%'; SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '%��%'; SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '%��'; #SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '�E��������������������������������������%'; #SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '%�E��������������������������������������%'; #SELECT * FROM `�s�P�P` WHERE `�b�P` LIKE '%�E��������������������������������������'; SELECT * FROM `�s�P�Q` WHERE `�b�P` LIKE '�\%'; SELECT * FROM `�s�P�Q` WHERE `�b�P` LIKE '%�\%'; SELECT * FROM `�s�P�Q` WHERE `�b�P` LIKE '%�\'; #SELECT * FROM `�s�P�Q` WHERE `�b�P` LIKE '�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\%'; #SELECT * FROM `�s�P�Q` WHERE `�b�P` LIKE '%�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\%'; #SELECT * FROM `�s�P�Q` WHERE `�b�P` LIKE '%�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\'; DROP TABLE `�s�P`; DROP TABLE `�s�Q`; DROP TABLE `�s�R`; DROP TABLE `�s�S`; DROP TABLE `�s�T`; DROP TABLE `�s�U`; DROP TABLE `�s�V`; DROP TABLE `�s�W`; DROP TABLE `�s�X`; DROP TABLE `�s�P�O`; DROP TABLE `�s�P�P`; DROP TABLE `�s�P�Q`;