SQLite data-types
Posted
by Alan Harris-Reid
on Stack Overflow
See other posts from Stack Overflow
or by Alan Harris-Reid
Published on 2010-05-03T22:11:40Z
Indexed on
2010/05/03
22:18 UTC
Read the original article
Hit count: 534
Hi there,
When creating a table in SQLite3, I 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
© Stack Overflow or respective owner