mysqldump + enum + default + umlaut (3)

Meanwhile, I have investigated a bit more and narrowed down
the problem. It only happens with our full table description - not with
a table with only a single column:


DROP TABLE IF EXISTS `artikel`;
CREATE TABLE `artikel` (
`t_changed` timestamp NOT NULL default CURRENT_TIMESTAMP on update=20
CURRENT_TIMESTAMP,
`t_created` timestamp NOT NULL default '0000-00-00 00:00:00',
`t_changed_bd` timestamp NOT NULL default '0000-00-00 00:00:00',
`uppdaterad` timestamp NOT NULL default '0000-00-00 00:00:00',
`granskad` enum('Ja','Nej') NOT NULL default 'Nej',
`artikelnummer` varchar(13) NOT NULL default '',
`hanvisnings_isbn` varchar(13) NOT NULL default '',
`ean` varchar(16) NOT NULL default '',
`titel` varchar(255) NOT NULL default '',
`arbetstitel` varchar(255) NOT NULL default '',
`interntitel` varchar(255) NOT NULL default '',
`mediatyp`=20
enum('Bok','Ljudbok','Multimedia','Marknadsföringsmaterial ','Övrigt')=20=

NOT NULL default 'Övrigt',
`bandtyp` varchar(32) NOT NULL default '',
`forlag_id` int(11) NOT NULL default '0',
`forlag` varchar(255) NOT NULL default '',
`distributor_id` int(11) NOT NULL default '0',
`moms` float NOT NULL default '0',
`saljperiod` varchar(12) NOT NULL default '',
`utgivningsdatum` timestamp NOT NULL default '0000-00-00 00:00:00',
`upplagenummer` int(11) NOT NULL default '0',
`omfang` int(11) NOT NULL default '0',
`omfang_typ` enum('','sidor','CD','Kassett','DVD') NOT NULL default=20=

'',
`bredd` int(11) NOT NULL default '0',
`hojd` int(11) NOT NULL default '0',
`ryggbredd` int(11) NOT NULL default '0',
`vikt` int(11) NOT NULL default '0',
`paket` enum('','Ja','Nej') NOT NULL default '',
`paket_typ` enum('','A','B','C','D') NOT NULL default '',
`antal_per_forpackning` int(11) NOT NULL default '0',
`komponent` varchar(255) NOT NULL default '',
`rea_ar` timestamp NOT NULL default '0000-00-00 00:00:00',
`rea_fpris` float NOT NULL default '0',
`reapris_fran_datum` timestamp NOT NULL default '0000-00-00 =
00:00:00',
`illustrerad` enum('','Ja','Nej') NOT NULL default '',
`laromedel` enum('','Ja','Nej') NOT NULL default '',
`originaltitel` varchar(255) NOT NULL default '',
`originalforlag` varchar(255) NOT NULL default '0',
`bic` varchar(255) NOT NULL default '',
`serie` varchar(128) NOT NULL default '',
`lasordning` varchar(32) NOT NULL default '',
`varugrupp` varchar(64) NOT NULL default '',
`saga` text NOT NULL,
`aldersgrupp` enum('','0-3','3-6','6-9','9-12','12-15','Unga vuxna')=20=

NOT NULL default '',
`katalogtext` text NOT NULL,
`kommentarfalt` varchar(255) NOT NULL default '',
`internforfattare` text NOT NULL,
PRIMARY KEY (`artikelnummer`),
KEY `mediatyp` (`mediatyp`),
KEY `bandtyp` (`bandtyp`),
KEY `serie` (`serie`),
KEY `bic` (`bic`),
KEY `varugrupp` (`varugrupp`),
KEY `interntitel` (`interntitel`),
KEY `ean` (`ean`),
KEY `originaltitel` (`originaltitel`),
KEY `originalforlag` (`originalforlag`),
KEY `rea_ar` (`rea_ar`),
KEY `upplagenummer` (`upplagenummer`),
KEY `forlag_id` (`forlag_id`),
KEY `distributor_id` (`distributor_id`),
KEY `t_changed` (`t_changed`),
KEY `t_created` (`t_created`),
KEY `saljperiod` (`saljperiod`),
KEY `t_changed_bd` (`t_changed_bd`)
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1;


Try to pipe this into 'mysql test' and then run 'mysqldump test=20
artikel' and see
how the mediatyp column will look in the dumped text.

Andreas Pardeike=


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org