Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Same DBI query gives different results on 32 & 64 bit boxesby cenobite1066 (Novice) |
on May 29, 2009 at 16:48 UTC ( [id://766890]=perlquestion: print w/replies, xml ) | Need Help?? |
cenobite1066 has asked for the wisdom of the Perl Monks concerning the following question:
Blessed Monks,
I have used DBI to execute a fairly complex SQL query via ODBC on an Oracle database, and it's run without a hitch for years on a 32-bit XP box (Perl v5.6.1)
Now I'm migrating the exact same query to a 64-bit XP server(Perl v5.10, 64bit), and the results are different.
It seems that certain fields, almost all certainly ints/floats, are now returning zero instead of the expected values. All other string/date fields return OK, it's just numbers that come back as zero. It's not a problem with the DB as the 32-bit query still runs OK.
Is there any difference in the type interpretation of the later 64-bit DBI/DBD code? Also, any SQL based tips are appreciated
Thanks
SOLVED Thanks Tye, CAST(field as VARCHAR(50)) retrieves each problem field correctly. Appreciate the help.
Back to
Seekers of Perl Wisdom
|
|