Re: 22001 Data too long for column

[karl.rausing]

I have the exact same problem. If I try to insert a single swedish character (for example, å) into an utf8_general_ci column, I get the error

"Data too long for column 'firstname' at row 1". If I insert text that does not have any special characters (for example, "test") it works. What could the problem be?

Edit: The column datatype is mediumtext

Edit2: This happens in the MySql console as well.
mysql> insert into clients SET firstnameinvoicingaddress = 'åäö';
ERROR 1406 (22001): Data too long for column 'firstnameinvoicingaddress' at row 1





Edited 2 time(s). Last edit at 03/12/2006 11:11AM by karl.rausing.