Skip Menu |

This queue is for tickets about the DBI CPAN distribution.

Report information
The Basics
Id: 19196
Status: rejected
Priority: 0/
Queue: DBI

People
Owner: Nobody in particular
Requestors: ananomaly [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 1.50
Fixed in: (no value)



Subject: Mysql Unsigned Integer Fields
When using DBI to select unsigned integer fields from a MySQL database. DBI error is fetchrow_arrayref failed: no statement executing when the integer contained in the field was over 2147483647. It seems as though DBI is treating MySQL field type as a signed integer instead of unsigned as it is listed in the database. I was able to work around the problem by using MySQL CAST to change the type to from unsigned integer to char(10). CPU: AMD Opteron(tm) Processor 246 OS: CentOS release 4.3 (Final) Mysql: 5.0.18-0 DBI: 1.50 (current release) Perl: v5.8.5 built for x86_64-linux-thread-multi uname: Linux dev 2.6.9-34.EL #1 Thu Mar 9 06:03:30 GMT 2006 x86_64 x86_64 x86_64 GNU/Linux
This isn't a DBI issue. Please resubmit as a DBD::mysql issue.