Re: 22001 Data too long for column
Posted by: karl.rausing
Date: March 12, 2006 10:59AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
29844
October 30, 2005 11:16AM
12542
November 09, 2005 05:55AM
10291
November 11, 2005 07:12AM
10709
December 02, 2005 09:50PM
8356
January 02, 2006 03:43PM
7131
March 14, 2006 09:34PM
6690
August 23, 2006 06:24AM
6494
August 17, 2007 07:08AM
6614
March 13, 2008 10:29AM
13048
November 12, 2005 05:29PM
7679
June 09, 2006 03:39AM
10001
July 21, 2006 07:21AM
10315
November 15, 2005 01:01AM
6500
August 18, 2006 10:32AM
Re: 22001 Data too long for column
14394
March 12, 2006 10:59AM
6104
March 14, 2006 11:34PM
6020
February 13, 2007 04:57AM
5143
February 13, 2007 05:18AM
5766
October 09, 2007 02:56AM
5937
December 03, 2007 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.