Re: [pysqlite] retrieving 64-bit numbers from SQLite

Roger Binns <[email protected]> Fri, 12 Sep 2008 11:33:55 -0700
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bruce Greenblatt wrote:
> typeof(num) returns integer.

Ok, so that definitely means that SQLite is storing the content as a number.

> Sorry, I did not originally realize that your code below was what you 
> were suggesting I put into my Python script.

It isn't :-)  It is the C code in pysqlite that converts the number from
SQLite into a Python object and shows how the PyInt vs PyLong selection
is made so that you don't get truncation.

Run the pysqlite test suite:

 from pysqlite2 import test
 test.test()

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIyrYTmOOfHg372QQRAqO+AKCbP50dME6X1yiupIovDyKYMUc2vQCeNl3G
KLqd/lp9cVTIrILO4ISCg0g=
=+V7A
-----END PGP SIGNATURE-----