Has anyone been able to get Long Integers to work with a SQLite DB on
Android?
In particular, I am noticing some odd behavior with Webkit's Cache
Database. The expires column is always 0. After doing some testing,
I realized that SQLite will accept a value in the expires column up
to (2^31 - 1).
Here is a list of data types that are allowed in SQLite 3:
http://www.sqlite.org/datatype3.html
Note that there is no official long data type. It would be classified as
INTEGER or REAL. For actual long data types that don't seem to be stored
well in SQLite you might do better to store as TEXT
I spent 2 days trying to figure this out, and wouldn't you know it...2
minutes after posting to the group, I think I have figured out what I was
doing wrong.
In order to check my work, I was exporting the database to my local computer
and opening it with SQLite Administrator. The values were
3 matches
Mail list logo
