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 
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` 
enum('Bok','Ljudbok','Multimedia','Marknadsföringsmaterial','Övrigt') 
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 
'',
   `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') 
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=MyISAM DEFAULT CHARSET=latin1;


Try to pipe this into 'mysql test' and then run 'mysqldump test 
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/[email protected]