Re: [sqlite] SQLite datatypes

HEre's the doc: 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

Re: [sqlite] SQLite datatypes

On Mon, May 3, 2010 at 2:17 PM, Alan Harris-Reid 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

[sqlite] SQLite datatypes

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