Re: [sqlite] SQLite datatypes

[Paul Rigor (uci)]

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 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

Re: [sqlite] SQLite datatypes

[P Kishor]

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 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

[sqlite] SQLite datatypes

[Alan Harris-Reid]

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