[DBD-SQLite] Re: DBD::SQLite / 32-bit Perl and 64-bit INTEGER PRIMARY KEY

Adam Kennedy adamkennedybackup at gmail.com
Thu Oct 6 04:31:30 GMT 2011


Hi Matthias

I may not be the best person to address this question to, as I'm just
the release manager and crotchety old fogie of DBD::SQLite.

The question is best addressed to the DBD::SQLite mailing list.

dbd-sqlite at lists.scsys.co.uk (forwarded)

Adam K

On 5 October 2011 03:33, Matthias Waldorf <matthias.waldorf at zoom.de> wrote:
> Dear Adam,
>
> sorry if this a stupid question, but I could not find out how to use a
> 64-bit INTEGER PRIMARY KEY with a 32-bit version of Perl.
>
> My primary key is a 64-bit number stored as a 16-byte hexadecimal string. Is
> there a way to specify an hexadecimal number as INTEGER PRIMARY KEY for an
> INSERT, UPDATE or SELECT statement?
>
> Thank you very much for your help!
>
> Matthias
>



More information about the DBD-SQLite mailing list