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 and do a conversion outside of SQLite. I am by no means a database expert though, perhaps someone with more SQLite experience will chime in with a better explanation. Justin On Tue, Apr 13, 2010 at 9:18 AM, Jeff <[email protected]> wrote: > 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). Anything higher than this, and the value is always 0. > > The cache database uses Date.getTime() to populate this field. Since > this is a long, the value is always 0. > > Is this a bug in the Cache Database or the SQLite implementation? > > Jeff > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<android-developers%[email protected]> > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en > > To unsubscribe, reply using "remove me" as the subject. > -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
