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 > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ 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
