HEre's the doc: http://www.sqlite.org/datatype3.html
<http://www.sqlite.org/datatype3.html>Cheers, Paul On Mon, May 3, 2010 at 12:17 PM, Alan Harris-Reid < aharrisr...@googlemail.com> wrote: > Hi there, > > When creating a table in SQLite, I often get confused when confronted > with all the possible datatypes which imply similar contents, so could > anyone tell me the difference between the following data-types? > > INT, INTEGER, SMALLINT, TINYINT > DEC, DECIMAL > LONGCHAR, LONGVARCHAR > DATETIME, SMALLDATETIME > > Is there some documentation somewhere which lists the min./max. > capacities of the various data-types? For example, I guess smallint > holds a larger maximum value than tinyint, but a smaller value than > integer, but I have no idea of what these capacities are. > > Any help would be appreciated. > > Alan Harris-Reid > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Paul Rigor Pre-doctoral BIT Fellow and Graduate Student Institute for Genomics and Bioinformatics Donald Bren School of Information and Computer Sciences University of California, Irvine http://www.ics.uci.edu/~prigor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users