On Mon, May 3, 2010 at 2: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. >
Read the following carefully http://www.sqlite.org/datatype3.html > 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 > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users