On 5/7/08, Joanne Pham <[EMAIL PROTECTED]> 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.
Did you ask your colleagues in your own company who used bigint, boolean, int(1) as the data types as to where they got that information from, why they used these data types, and what advantages, if any, they perceived in using these data types. > 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 > > > > Note unrelated to this thread: You don't need to cc your reply to me. Just send the reply to the list. I am a member of the list. I will get it anyway. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
