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