--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 CONVERT() function with Japanese character 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 = heap; CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = heap; CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = heap; CREATE TABLE `�ԣ���` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = bdb; CREATE TABLE `�ԣ���` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = bdb; CREATE TABLE `�ԣ���` (`�ã�` char(20), INDEX(`�ã�`)) 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 `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; # The result will get garbled because jisx0212 is not included in sjis SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; #MyISAM SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; # The result will get garbled because jisx0212 is not included in sjis SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; #Heap SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ�`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ�`; # The result will get garbled because jisx0212 is not included in sjis SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ�`; #BDB SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ���`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ���`; SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ���`; SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ���`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ���`; SELECT `�ã�`, CONVERT(`�ã�` using sjis) FROM `�ԣ���`; SELECT `�ã�`, CONVERT(`�ã�` using utf8) FROM `�ԣ���`; SELECT `�ã�`, CONVERT(`�ã�` using ucs2) FROM `�ԣ���`; # The result will get garbled because jisx0212 is not included in sjis SELECT `�ã�`, CONVERT(`�ã�` using sjis) 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 `�ԣ���`;