[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'])