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
