Hello mysql, This bug make impossible to use backup with 'mysqldump','mysql' pair.
How-to-repeat: --------------------------- drop table if exists t1; drop table if exists t2; create table t1 (a int, b enum('А','Б')) DEFAULT CHARACTER SET cp1251; create table t2 (a int not null, b enum('А','Б')) DEFAULT CHARACTER SET cp1251; show fields from t1 like 'b'; show fields from t2 like 'b'; +---+---------------+-----+--+------+--+ | b | enum('А','Б') | YES | | NULL | | +---+---------------+-----+--+------+--+ | b | enum('А','Б') | YES | | NULL | | <------ Ok +---+---------------+-----+--+------+--+ show create table t1; show create table t2; +----+-------------------------------- | t1 | CREATE TABLE `t1` ( `a` int(11) default NULL, `b` enum('А','Б') default NULL ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 +----+-------------------------------- +----+-------------------------------- | t2 | CREATE TABLE `t2` ( `a` int(11) NOT NULL default '0', `b` enum('?','?') default NULL <------ Oops! ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 +----+-------------------------------- -- Best regards, Juri mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]