[sqlite] Number truncation problem in SQLite 3

[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: 9223372036854775807, so it should fit.

What am I doing wrong? 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users