drop table if exists `sP`; drop table if exists `sQ`; drop table if exists `sR`; drop table if exists `sS`; drop table if exists `sT`; drop table if exists `sU`; drop table if exists `sV`; drop table if exists `sW`; drop table if exists `sX`; drop table if exists t1; SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `sP` (`bP` ENUM('','',''), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sQ` (`bP` ENUM('','',''), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sR` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sS` (`bP` ENUM('','',''), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sT` (`bP` ENUM('','',''), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sU` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sV` (`bP` ENUM('','',''), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sW` (`bP` ENUM('','',''), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sX` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY; INSERT INTO `sP` VALUES (''),(''),(''); INSERT INTO `sQ` VALUES (''),(''),(''); INSERT INTO `sR` VALUES ('\'),('\'),('\'); INSERT INTO `sS` VALUES (''),(''),(''); INSERT INTO `sT` VALUES (''),(''),(''); INSERT INTO `sU` VALUES ('\'),('\'),('\'); INSERT INTO `sV` VALUES (''),(''),(''); INSERT INTO `sW` VALUES (''),(''),(''); INSERT INTO `sX` VALUES ('\'),('\'),('\'); SELECT * FROM `sP`; bP SELECT * FROM `sQ`; bP SELECT * FROM `sR`; bP \ \ \ SELECT * FROM `sS`; bP SELECT * FROM `sT`; bP SELECT * FROM `sU`; bP \ \ \ SELECT * FROM `sV`; bP SELECT * FROM `sW`; bP SELECT * FROM `sX`; bP \ \ \ SHOW CREATE TABLE `sP`; Table Create Table sP CREATE TABLE `sP` ( `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=InnoDB DEFAULT CHARSET=sjis SHOW CREATE TABLE `sQ`; Table Create Table sQ CREATE TABLE `sQ` ( `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=InnoDB DEFAULT CHARSET=sjis SHOW CREATE TABLE `sR`; Table Create Table sR CREATE TABLE `sR` ( `bP` enum('\','\','\') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=InnoDB DEFAULT CHARSET=sjis SHOW CREATE TABLE `sS`; Table Create Table sS CREATE TABLE `sS` ( `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MyISAM DEFAULT CHARSET=sjis SHOW CREATE TABLE `sT`; Table Create Table sT CREATE TABLE `sT` ( `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MyISAM DEFAULT CHARSET=sjis SHOW CREATE TABLE `sU`; Table Create Table sU CREATE TABLE `sU` ( `bP` enum('\','\','\') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MyISAM DEFAULT CHARSET=sjis SHOW CREATE TABLE `sV`; Table Create Table sV CREATE TABLE `sV` ( `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MEMORY DEFAULT CHARSET=sjis SHOW CREATE TABLE `sW`; Table Create Table sW CREATE TABLE `sW` ( `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MEMORY DEFAULT CHARSET=sjis SHOW CREATE TABLE `sX`; Table Create Table sX CREATE TABLE `sX` ( `bP` enum('\','\','\') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MEMORY DEFAULT CHARSET=sjis DESC `sP`; Field Type Null Key Default Extra bP enum('','','') YES MUL NULL DESC `sQ`; Field Type Null Key Default Extra bP enum('','','') YES MUL NULL DESC `sR`; Field Type Null Key Default Extra bP enum('\','\','\') YES MUL NULL DESC `sS`; Field Type Null Key Default Extra bP enum('','','') YES MUL NULL DESC `sT`; Field Type Null Key Default Extra bP enum('','','') YES MUL NULL DESC `sU`; Field Type Null Key Default Extra bP enum('\','\','\') YES MUL NULL DESC `sV`; Field Type Null Key Default Extra bP enum('','','') YES MUL NULL DESC `sW`; Field Type Null Key Default Extra bP enum('','','') YES MUL NULL DESC `sX`; Field Type Null Key Default Extra bP enum('\','\','\') YES MUL NULL ALTER TABLE `sP` ADD `bQ` CHAR(1) NOT NULL FIRST; ALTER TABLE `sQ` ADD `bQ` CHAR(1) NOT NULL FIRST; ALTER TABLE `sR` ADD `bQ` CHAR(1) NOT NULL FIRST; ALTER TABLE `sS` ADD `bQ` CHAR(1) NOT NULL FIRST; ALTER TABLE `sT` ADD `bQ` CHAR(1) NOT NULL FIRST; ALTER TABLE `sU` ADD `bQ` CHAR(1) NOT NULL FIRST; ALTER TABLE `sV` ADD `bQ` CHAR(1) NOT NULL FIRST; ALTER TABLE `sW` ADD `bQ` CHAR(1) NOT NULL FIRST; ALTER TABLE `sX` ADD `bQ` CHAR(1) NOT NULL FIRST; SHOW CREATE TABLE `sP`; Table Create Table sP CREATE TABLE `sP` ( `bQ` char(1) NOT NULL, `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=InnoDB DEFAULT CHARSET=sjis SHOW CREATE TABLE `sQ`; Table Create Table sQ CREATE TABLE `sQ` ( `bQ` char(1) NOT NULL, `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=InnoDB DEFAULT CHARSET=sjis SHOW CREATE TABLE `sR`; Table Create Table sR CREATE TABLE `sR` ( `bQ` char(1) NOT NULL, `bP` enum('\','\','\') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=InnoDB DEFAULT CHARSET=sjis SHOW CREATE TABLE `sS`; Table Create Table sS CREATE TABLE `sS` ( `bQ` char(1) NOT NULL, `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MyISAM DEFAULT CHARSET=sjis SHOW CREATE TABLE `sT`; Table Create Table sT CREATE TABLE `sT` ( `bQ` char(1) NOT NULL, `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MyISAM DEFAULT CHARSET=sjis SHOW CREATE TABLE `sU`; Table Create Table sU CREATE TABLE `sU` ( `bQ` char(1) NOT NULL, `bP` enum('\','\','\') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MyISAM DEFAULT CHARSET=sjis SHOW CREATE TABLE `sV`; Table Create Table sV CREATE TABLE `sV` ( `bQ` char(1) NOT NULL, `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MEMORY DEFAULT CHARSET=sjis SHOW CREATE TABLE `sW`; Table Create Table sW CREATE TABLE `sW` ( `bQ` char(1) NOT NULL, `bP` enum('','','') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MEMORY DEFAULT CHARSET=sjis SHOW CREATE TABLE `sX`; Table Create Table sX CREATE TABLE `sX` ( `bQ` char(1) NOT NULL, `bP` enum('\','\','\') DEFAULT NULL, KEY `bP` (`bP`) ) ENGINE=MEMORY DEFAULT CHARSET=sjis CREATE TABLE t1(c1 enum('S','s')) default character set = sjis; INSERT INTO t1 VALUES('S'),('s'); SELECT * FROM t1 WHERE c1 LIKE 'S'; c1 S DROP TABLE t1; DESC `sP`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('','','') YES MUL NULL DESC `sQ`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('','','') YES MUL NULL DESC `sR`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('\','\','\') YES MUL NULL DESC `sS`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('','','') YES MUL NULL DESC `sT`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('','','') YES MUL NULL DESC `sU`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('\','\','\') YES MUL NULL DESC `sV`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('','','') YES MUL NULL DESC `sW`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('','','') YES MUL NULL DESC `sX`; Field Type Null Key Default Extra bQ char(1) NO NULL bP enum('\','\','\') YES MUL NULL DROP TABLE `sP`; DROP TABLE `sQ`; DROP TABLE `sR`; DROP TABLE `sS`; DROP TABLE `sT`; DROP TABLE `sU`; DROP TABLE `sV`; DROP TABLE `sW`; DROP TABLE `sX`;