--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 `龗龗龗`; DROP TABLE IF EXISTS `龞龞龞`; DROP TABLE IF EXISTS `龡龡龡`; DROP TABLE IF EXISTS `龢龢龢`; --enable_warnings # # Test creating table with Japanese characters in utf8 encoding # SET NAMES utf8; SET character_set_database = utf8; CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; # Tables should not be created because table names exist CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; # Tables should be created CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; DESC `アアア`; DESC `イイイ`; DESC `ウウウ`; DESC `エエエ`; DESC `オオオ`; DESC `あああ`; DESC `いいい`; DESC `ううう`; DESC `えええ`; DESC `おおお`; DESC `龖龖龖`; DESC `龗龗龗`; DESC `龞龞龞`; DESC `龡龡龡`; DESC `龢龢龢`; SHOW CREATE TABLE `アアア`; SHOW CREATE TABLE `イイイ`; SHOW CREATE TABLE `ウウウ`; SHOW CREATE TABLE `エエエ`; SHOW CREATE TABLE `オオオ`; SHOW CREATE TABLE `あああ`; SHOW CREATE TABLE `いいい`; SHOW CREATE TABLE `ううう`; SHOW CREATE TABLE `えええ`; SHOW CREATE TABLE `おおお`; SHOW CREATE TABLE `龖龖龖`; SHOW CREATE TABLE `龗龗龗`; SHOW CREATE TABLE `龞龞龞`; SHOW CREATE TABLE `龡龡龡`; SHOW CREATE TABLE `龢龢龢`; DROP TABLE `アアア`; DROP TABLE `イイイ`; DROP TABLE `ウウウ`; DROP TABLE `エエエ`; DROP TABLE `オオオ`; DROP TABLE `あああ`; DROP TABLE `いいい`; DROP TABLE `ううう`; DROP TABLE `えええ`; DROP TABLE `おおお`; DROP TABLE `龖龖龖`; DROP TABLE `龗龗龗`; DROP TABLE `龞龞龞`; DROP TABLE `龡龡龡`; DROP TABLE `龢龢龢`; CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; # Tables should not be created because table names exist CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; # Tables should be created CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; DESC `アアア`; DESC `イイイ`; DESC `ウウウ`; DESC `エエエ`; DESC `オオオ`; DESC `あああ`; DESC `いいい`; DESC `ううう`; DESC `えええ`; DESC `おおお`; DESC `龖龖龖`; DESC `龗龗龗`; DESC `龞龞龞`; DESC `龡龡龡`; DESC `龢龢龢`; SHOW CREATE TABLE `アアア`; SHOW CREATE TABLE `イイイ`; SHOW CREATE TABLE `ウウウ`; SHOW CREATE TABLE `エエエ`; SHOW CREATE TABLE `オオオ`; SHOW CREATE TABLE `あああ`; SHOW CREATE TABLE `いいい`; SHOW CREATE TABLE `ううう`; SHOW CREATE TABLE `えええ`; SHOW CREATE TABLE `おおお`; SHOW CREATE TABLE `龖龖龖`; SHOW CREATE TABLE `龗龗龗`; SHOW CREATE TABLE `龞龞龞`; SHOW CREATE TABLE `龡龡龡`; SHOW CREATE TABLE `龢龢龢`; DROP TABLE `アアア`; DROP TABLE `イイイ`; DROP TABLE `ウウウ`; DROP TABLE `エエエ`; DROP TABLE `オオオ`; DROP TABLE `あああ`; DROP TABLE `いいい`; DROP TABLE `ううう`; DROP TABLE `えええ`; DROP TABLE `おおお`; DROP TABLE `龖龖龖`; DROP TABLE `龗龗龗`; DROP TABLE `龞龞龞`; DROP TABLE `龡龡龡`; DROP TABLE `龢龢龢`; CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; # Tables should not be created because table names exist CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; # Tables should be created CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; DESC `アアア`; DESC `イイイ`; DESC `ウウウ`; DESC `エエエ`; DESC `オオオ`; DESC `あああ`; DESC `いいい`; DESC `ううう`; DESC `えええ`; DESC `おおお`; DESC `龖龖龖`; DESC `龗龗龗`; DESC `龞龞龞`; DESC `龡龡龡`; DESC `龢龢龢`; SHOW CREATE TABLE `アアア`; SHOW CREATE TABLE `イイイ`; SHOW CREATE TABLE `ウウウ`; SHOW CREATE TABLE `エエエ`; SHOW CREATE TABLE `オオオ`; SHOW CREATE TABLE `あああ`; SHOW CREATE TABLE `いいい`; SHOW CREATE TABLE `ううう`; SHOW CREATE TABLE `えええ`; SHOW CREATE TABLE `おおお`; SHOW CREATE TABLE `龖龖龖`; SHOW CREATE TABLE `龗龗龗`; SHOW CREATE TABLE `龞龞龞`; SHOW CREATE TABLE `龡龡龡`; SHOW CREATE TABLE `龢龢龢`; DROP TABLE `アアア`; DROP TABLE `イイイ`; DROP TABLE `ウウウ`; DROP TABLE `エエエ`; DROP TABLE `オオオ`; DROP TABLE `あああ`; DROP TABLE `いいい`; DROP TABLE `ううう`; DROP TABLE `えええ`; DROP TABLE `おおお`; DROP TABLE `龖龖龖`; DROP TABLE `龗龗龗`; DROP TABLE `龞龞龞`; DROP TABLE `龡龡龡`; DROP TABLE `龢龢龢`; CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=BDB; # Tables should not be created because table names exist CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=BDB; # Tables should be created CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=BDB; CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=BDB; DESC `アアア`; DESC `イイイ`; DESC `ウウウ`; DESC `エエエ`; DESC `オオオ`; DESC `あああ`; DESC `いいい`; DESC `ううう`; DESC `えええ`; DESC `おおお`; DESC `龖龖龖`; DESC `龗龗龗`; DESC `龞龞龞`; DESC `龡龡龡`; DESC `龢龢龢`; SHOW CREATE TABLE `アアア`; SHOW CREATE TABLE `イイイ`; SHOW CREATE TABLE `ウウウ`; SHOW CREATE TABLE `エエエ`; SHOW CREATE TABLE `オオオ`; SHOW CREATE TABLE `あああ`; SHOW CREATE TABLE `いいい`; SHOW CREATE TABLE `ううう`; SHOW CREATE TABLE `えええ`; SHOW CREATE TABLE `おおお`; SHOW CREATE TABLE `龖龖龖`; SHOW CREATE TABLE `龗龗龗`; SHOW CREATE TABLE `龞龞龞`; SHOW CREATE TABLE `龡龡龡`; SHOW CREATE TABLE `龢龢龢`; DROP TABLE `アアア`; DROP TABLE `イイイ`; DROP TABLE `ウウウ`; DROP TABLE `エエエ`; DROP TABLE `オオオ`; DROP TABLE `あああ`; DROP TABLE `いいい`; DROP TABLE `ううう`; DROP TABLE `えええ`; DROP TABLE `おおお`; DROP TABLE `龖龖龖`; DROP TABLE `龗龗龗`; DROP TABLE `龞龞龞`; DROP TABLE `龡龡龡`; DROP TABLE `龢龢龢`;