Re: 22001 Data too long for column

[Janos Hajdu]

I had a same problem.
First I worked with Latin2 default character set, and I made a dump. After it I changed tables default caharacter set to utf8 and I restore chema. In Query Browser I saw only: "Column Charset: Default".
But in the dump file I saw:

CREATE TABLE `forras` (
`azonosito` int(10) unsigned NOT NULL auto_increment,
`nev` varchar(45) character set latin2 collate latin2_hungarian_ci NOT NULL default '',
PRIMARY KEY (`azonosito`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I changed it manually:

CREATE TABLE `forras` (
`azonosito` int(10) unsigned NOT NULL auto_increment,
`nev` varchar(45) character set utf8 NOT NULL default '',
PRIMARY KEY (`azonosito`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and it works well!!
In Query Browser I see "Column charset utf8".