Re: 22001 Data too long for column
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.
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
7510
January 16, 2006 12:56PM
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
5523
May 01, 2006 12:46AM
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
4993
April 03, 2006 06:54AM
9850
May 01, 2006 10:18PM
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.