Re: 22001 Data too long for column
Posted by: jj virus
Date: October 09, 2007 02:56AM

just set names to latin1 before you insert:
mysql> set names latin1;
mysql> insert into...
I had the same problem, it works fine now.

Options: ReplyQuote


Subject
Views
Written By
Posted
29342
October 30, 2005 11:16AM
12402
November 09, 2005 05:55AM
10145
November 11, 2005 07:12AM
10597
December 02, 2005 09:50PM
8217
January 02, 2006 03:43PM
6997
March 14, 2006 09:34PM
6552
August 23, 2006 06:24AM
6336
August 17, 2007 07:08AM
6478
March 13, 2008 10:29AM
12888
November 12, 2005 05:29PM
7527
June 09, 2006 03:39AM
9831
July 21, 2006 07:21AM
10157
November 15, 2005 01:01AM
6326
August 18, 2006 10:32AM
14181
March 12, 2006 10:59AM
5973
March 14, 2006 11:34PM
5866
February 13, 2007 04:57AM
5012
February 13, 2007 05:18AM
Re: 22001 Data too long for column
5631
October 09, 2007 02:56AM
5785
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.