[pysqlite] retrieving 64-bit numbers from SQLite
Bruce Greenblatt <bgreenblatt-/[email protected]> Wed, 10 Sep 2008 15:37:52 -0700 (PDT)
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
When I retrieve large numbers from a SQLite table, they seem to be getting truncated to 32-bits, and treated as signed integers.
My code is pretty simple:
stmt = """
SELECT name, num FROM stats ORDER BY num DESC LIMIT 50;
"""
cur = self.con.cursor()
cur.execute(stmt)
for row in cur:
names.append(row['name'])
nums.append(row['num'])