They are all type INTEGER, essentially a 64 bit signed integer. Joanne Pham wrote: > Hi , >> "Can you direct us where you find out that "SQLITE3 has bigint and int" >> as datatypes?" > > Not on any website but one of another project in my company using sqlite and > they created one of the using bigint, boolean, int(1) > as the datatype and I have tried these datatype to create the table and the > table is created sucessfully without any problem. So > I was wondering what is the different in size between int(8) and INTEGER > datatype. > Thanks, > JP > > > ----- Original Message ---- > From: P Kishor <[EMAIL PROTECTED]> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Sent: Wednesday, May 7, 2008 10:08:54 AM > Subject: Re: [sqlite] SQLITE3 datatype > > On 5/7/08, Joanne Pham <[EMAIL PROTECTED]> wrote: >> Hi All, >> I have read online document regarding SQLITE3 data type and below is list >> of these datatypes: >> * TEXT >> * NUMERIC >> * INTEGER >> * REAL >> * NONE >> But just now I found out SQLITE3 has bigint and int as another datatype. >> Can you direct me where I can find out the complete list of SQLITE >> datatypes and the size of each datatype. > > Can you direct us where you find out that "SQLITE3 has bigint and int" > as datatypes? > > >> Thanks, >> JP >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> >> >> ____________________________________________________________________________________ >> Be a better friend, newshound, and >> know-it-all with Yahoo! Mobile. Try it now. >> http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
