I'm trying to use DBI and DBD::mysql with perl-5.8.8 on a 64bit Redhat host: Linux host 2.6.9-67.0.20.ELsmp #1 SMP Wed Jun 18 12:35:02 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
I need to do table lookups based on a column of type bigint. I don't generate or manipulate the bigint value myself - I actually read it in from the database. But when I turn around and try to select on the bigint value, it is not found. I scanned the web etc and have tried "use bigint", quoting the value, forcing it to be string, etc. Testing shows that defining a large int as a string and inserting it into the database works fine (I pass $query to prepare() and $token to execute()): my $token = "18288286186892797895"; $query = "insert into table (uid, token) VALUES (9, ?)"; But I cannot figure out a way to turn around and select on that same token. For instance, these do nothing: $query = "UPDATE table set uid = 8 where (uid = 9) and (token = ?)"; OR $query = "SELECT * from table where (uid = 9) and (token = ?)"; If I try a smaller number for token, everything works as expected. Tod Sandman Sr. Systems Administrator Middleware Development & Integration Rice University Voice: 713.348.5816
