Re: mysql and large integers

2004-12-03 Thread Mark Maunder
Thanks very much Paul. My day has just improved. On Fri, 2004-12-03 at 16:53, Paul DuBois wrote: > At 16:34 -0800 12/3/04, Mark Maunder wrote: > >It looks like when mysql coerces character strings into integers, it > >turns them into signed int's. Obviously if the column is unsigned, this > >is a

Re: mysql and large integers

2004-12-03 Thread Paul DuBois
At 16:34 -0800 12/3/04, Mark Maunder wrote: It looks like when mysql coerces character strings into integers, it turns them into signed int's. Obviously if the column is unsigned, this is a problem. Don't use quotes you say. Problem is that the perl DBI API seems to put quotes around everything. So

mysql and large integers

2004-12-03 Thread Mark Maunder
It looks like when mysql coerces character strings into integers, it turns them into signed int's. Obviously if the column is unsigned, this is a problem. Don't use quotes you say. Problem is that the perl DBI API seems to put quotes around everything. So when I grab a really really large integer f