Re: 22001 Data too long for column
Posted by: thorsten.moeller
Date: April 03, 2006 06:54AM

huang my wrote:
> Execute "set names=..." doesn't seem to work.
>
> I modify the file "my.ini" and set
> default-character-set=utf8 in "SERVER
> SECTION",then restart the MySql service.This time
> I succeed.
> (windows XP sp2)
>
> Everyone here can try this approach.

Hi,

I am experiencing this behaviour as well with utf8 set in my.ini. In my case the problem seems to be an "@" in a field containing a mailaddress.

As i have no control on how the file ist generated i need an other option

Any suggestions??

Thorsten

Options: ReplyQuote


Subject
Views
Written By
Posted
29321
October 30, 2005 11:16AM
12393
November 09, 2005 05:55AM
10136
November 11, 2005 07:12AM
10591
December 02, 2005 09:50PM
8206
January 02, 2006 03:43PM
6988
March 14, 2006 09:34PM
6546
August 23, 2006 06:24AM
6331
August 17, 2007 07:08AM
6472
March 13, 2008 10:29AM
12875
November 12, 2005 05:29PM
7520
June 09, 2006 03:39AM
9822
July 21, 2006 07:21AM
10150
November 15, 2005 01:01AM
6317
August 18, 2006 10:32AM
14172
March 12, 2006 10:59AM
5966
March 14, 2006 11:34PM
Re: 22001 Data too long for column
4872
April 03, 2006 06:54AM
5856
February 13, 2007 04:57AM
5004
February 13, 2007 05:18AM
5624
October 09, 2007 02:56AM
5779
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.