Re: [sqlite] Number truncation problem in SQLite 3

2009-07-12 Thread Jim Showalter
009 4:25 PM Subject: Re: [sqlite] Number truncation problem in SQLite 3 > On 13/07/2009 8:40 AM, Roger Binns wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> Jim Showalter wrote: >>> create table words (_id integer primary key autoincrement

Re: [sqlite] Number truncation problem in SQLite 3

2009-07-12 Thread John Machin
On 13/07/2009 8:40 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Jim Showalter wrote: >> create table words (_id integer primary key autoincrement, wordtext >> text not null unique, timestamp integer not null); >> >> public class Word >> { >> long _id; >>

Re: [sqlite] Number truncation problem in SQLite 3

2009-07-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jim Showalter wrote: > create table words (_id integer primary key autoincrement, wordtext > text not null unique, timestamp integer not null); > > public class Word > { > long _id; > String wordtext; > long timestamp; > } > >

[sqlite] Number truncation problem in SQLite 3

2009-07-12 Thread Jim Showalter
create table words (_id integer primary key autoincrement, wordtext text not null unique, timestamp integer not null); public class Word { long _id; String wordtext; long timestamp; } timestamp: before save: 1247435151517 after save : 1247435160847 64-bit max is: