--source include/have_ujis.inc
--source include/have_innodb.inc

--disable_warnings
drop table if exists `｣ﾔ｣ｱ`;
drop table if exists `｣ﾔ｣ｲ`;
drop table if exists `｣ﾔ｣ｳ`;
drop table if exists `｣ﾔ｣ｴ`;
drop table if exists `｣ﾔ｣ｵ`;
drop table if exists `｣ﾔ｣ｶ`;
drop table if exists `｣ﾔ｣ｷ`;
drop table if exists `｣ﾔ｣ｸ`;
drop table if exists `｣ﾔ｣ｹ`;
--enable_warnings

#
# Test Displaying Japanese charact using WHERE condtion in ujis encoding
#

SET NAMES ujis;
SET character_set_database = ujis;

CREATE TABLE `｣ﾔ｣ｱ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `｣ﾔ｣ｲ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `｣ﾔ｣ｳ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `｣ﾔ｣ｴ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `｣ﾔ｣ｵ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `｣ﾔ｣ｶ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `｣ﾔ｣ｷ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `｣ﾔ｣ｸ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `｣ﾔ｣ｹ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = MEMORY;

#Load the following data in each table
# jisx0201 hankaku-katakana data
# jisx0208 data
# jisx0212 supplemental character data

LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `｣ﾔ｣ｱ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `｣ﾔ｣ｲ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `｣ﾔ｣ｳ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `｣ﾔ｣ｴ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `｣ﾔ｣ｵ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `｣ﾔ｣ｶ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `｣ﾔ｣ｷ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `｣ﾔ｣ｸ`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `｣ﾔ｣ｹ`;

#InnoDB
SELECT * FROM `｣ﾔ｣ｱ` WHERE `｣ﾃ｣ｱ` = '鴫竺軸宍雫七叱執失嫉室悉湿漆疾質';
SELECT * FROM `｣ﾔ｣ｲ` WHERE `｣ﾃ｣ｱ` = '｡ｦ､｡､｢､｣､､､･､ｦ､ｧ､ｨ､ｩ､ｪ､ｫ､ｬ､ｭ､ｮ､ｯ､ｰ､ｱ､ｲ､ｳ';
SELECT * FROM `｣ﾔ｣ｳ` WHERE `｣ﾃ｣ｱ` = '常ｴ常ｵ常ｶ常ｷ常ｸ常ｹ常ｺ常ｻ常ｼ常ｽ常ｾ常ｿ常ﾀ常ﾁ常ﾂ常ﾃ常ﾄ常ﾅ常ﾆ常ﾇ';

#MyISAM
SELECT * FROM `｣ﾔ｣ｴ` WHERE `｣ﾃ｣ｱ` = '鴫竺軸宍雫七叱執失嫉室悉湿漆疾質';
SELECT * FROM `｣ﾔ｣ｵ` WHERE `｣ﾃ｣ｱ` = '｡ｦ､｡､｢､｣､､､･､ｦ､ｧ､ｨ､ｩ､ｪ､ｫ､ｬ､ｭ､ｮ､ｯ､ｰ､ｱ､ｲ､ｳ';
SELECT * FROM `｣ﾔ｣ｶ` WHERE `｣ﾃ｣ｱ` = '常ｴ常ｵ常ｶ常ｷ常ｸ常ｹ常ｺ常ｻ常ｼ常ｽ常ｾ常ｿ常ﾀ常ﾁ常ﾂ常ﾃ常ﾄ常ﾅ常ﾆ常ﾇ';

#MEMORY
SELECT * FROM `｣ﾔ｣ｷ` WHERE `｣ﾃ｣ｱ` = '鴫竺軸宍雫七叱執失嫉室悉湿漆疾質';
SELECT * FROM `｣ﾔ｣ｸ` WHERE `｣ﾃ｣ｱ` = '｡ｦ､｡､｢､｣､､､･､ｦ､ｧ､ｨ､ｩ､ｪ､ｫ､ｬ､ｭ､ｮ､ｯ､ｰ､ｱ､ｲ､ｳ';
SELECT * FROM `｣ﾔ｣ｹ` WHERE `｣ﾃ｣ｱ` = '常ｴ常ｵ常ｶ常ｷ常ｸ常ｹ常ｺ常ｻ常ｼ常ｽ常ｾ常ｿ常ﾀ常ﾁ常ﾂ常ﾃ常ﾄ常ﾅ常ﾆ常ﾇ';

DROP TABLE `｣ﾔ｣ｱ`;
DROP TABLE `｣ﾔ｣ｲ`;
DROP TABLE `｣ﾔ｣ｳ`;
DROP TABLE `｣ﾔ｣ｴ`;
DROP TABLE `｣ﾔ｣ｵ`;
DROP TABLE `｣ﾔ｣ｶ`;
DROP TABLE `｣ﾔ｣ｷ`;
DROP TABLE `｣ﾔ｣ｸ`;
DROP TABLE `｣ﾔ｣ｹ`;