--source include/have_ujis.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 `�ԣ�`; drop table if exists `�ԣ���`; drop table if exists `�ԣ���`; drop table if exists `�ԣ���`; --enable_warnings # # Test Displaying Japanese charact in ujis encoding # SET NAMES ujis; SET character_set_database = ujis; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = innodb; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = innodb; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = innodb; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = myisam; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = myisam; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = myisam; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = heap; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = heap; CREATE TABLE `�ԣ�` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = heap; CREATE TABLE `�ԣ���` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = bdb; CREATE TABLE `�ԣ���` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = bdb; CREATE TABLE `�ԣ���` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ujis engine = bdb; #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 `�ԣ�`; 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 `�ԣ�`; SELECT * FROM `�ԣ�`; SELECT * FROM `�ԣ�`; #MyISAM SELECT * FROM `�ԣ�`; SELECT * FROM `�ԣ�`; SELECT * FROM `�ԣ�`; #Heap SELECT * FROM `�ԣ�`; SELECT * FROM `�ԣ�`; SELECT * FROM `�ԣ�`; #BDB SELECT * FROM `�ԣ���`; SELECT * FROM `�ԣ���`; SELECT * FROM `�ԣ���`; drop table `�ԣ�`; drop table `�ԣ�`; drop table `�ԣ�`; drop table `�ԣ�`; drop table `�ԣ�`; drop table `�ԣ�`; drop table `�ԣ�`; drop table `�ԣ�`; drop table `�ԣ�`; drop table `�ԣ���`; drop table `�ԣ���`; drop table `�ԣ���`;