Bug #21442 Err 1265 - Data truncated for column

• Submitted: 4 Aug 2006 9:16
• Modified: 5 Aug 2006 15:13
• Reporter: Steven Ebeling
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.1
• OS: Windows (win2003)
• CPU Architecture: Any

[4 Aug 2006 9:16] Steven Ebeling

Description:
CREATE TABLE `glossar_deu` (
  `glossar_id` int(10) unsigned NOT NULL auto_increment,
  `glossar_headline` varchar(100) NOT NULL default '',
  `glossar_content` text,
  `glossar_bild` varchar(255) default NULL,
  `glossar_wvl` enum('nein','ja') NOT NULL default 'nein',
  `glossar_link` varchar(10) default NULL,
  `glossar_link_text` varchar(100) default NULL,
  `glossar_link2` varchar(10) default NULL,
  `glossar_link_text2` varchar(100) default NULL,
  `glossar_link3` varchar(10) default NULL,
  `glossar_link_text3` varchar(100) default NULL,
  `glossar_hard` tinyint(3) default '0',
  `glossar_soft` tinyint(3) unsigned default '0',
  `glossar_label` tinyint(3) unsigned default '0',
  PRIMARY KEY  (`glossar_id`),
  UNIQUE KEY `glossar_id_2` (`glossar_id`),
  KEY `glossar_id` (`glossar_id`),
  FULLTEXT KEY `glossar_headline` (`glossar_headline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `glossar_deu` VALUES ('1', 'zbik sss', 'zbiktest\r\n\r\nasdasdasd', null, '', '43', '', '', '', '', '', '0', '0', '0');

// ERROR
Err	1265 - Data truncated for column 'glossar_wvl' at row 1 With statement: INSERT INTO `glossar_deu` VALUES ('1', 'zbik sss', 'zbiktest\r\n\r\nasdasdasd', null, '', '43', '', '', '', '', '', '0', '0', '0')

How to repeat:
...

[5 Aug 2006 15:13] Hartmut Holzgraefe

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.