|
Posted by web on December 13, 2004, 1:02 am
Please log in for more thread options
I would appreciate some guidance on an issue I'm experiencing...
I'm using DBD::SQLite in an application with large integer values (> 32
bits). The values are handled fine in sqlite itself. Just FYI, the
sqlite documentation specifically says the following regarding the
INTEGER data type:
"The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes
depending on the magnitude of the value."
However, by the time the values gets to Perl, they're corrupt; even
though the version of Perl that I'm using (5.8.5) has support for
64-bit integers. Here's some partial output from "perl -V".
Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_LARGE_FILES
Built under linux
Apparently there's a problem in passing the larger integer values
through the DBD::SQLite interface. The version of DBD::SQLite is 1.07.
I've done some investigation into the issue, but I haven't found any
satisfactory answers. Any help would be appreciated.
Thanks!
| 
XML Sitemap