-----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; > } > > timestamp: > before save: 1247435151517 > after save : 1247435160847 > > 64-bit max is: 9223372036854775807, so it should fit.
http://catb.org/esr/faqs/smart-questions.html Your mailer headers show that you are using Windows. On Windows (including a 64 bit environment) long is 32 bits. http://blogs.msdn.com/oldnewthing/archive/2005/01/31/363790.aspx Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpaZl0ACgkQmOOfHg372QR3OQCeJN8iq1kfjjM5Lel8qGToQ06j /ocAoLdOsq3gVaf5mNAiWanqfQN6dxSe =9JUC -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users