Hi,

     I found an offical mention here: http://www.sqlite.org/datatype3.html

     but seems not a "full list", because it only mention some "Affinity". I
want a full list of ALL VALID  data types that sqlite really support, here
is my result, does anyone could make it really full list?

REAL
FLOA  (FLOAT will do??)
DOUB  (DOUBLE will do??)
INT    (duplicate with INTEGER??)
INTEGER
NUMERIC
DATETIME
CHAR
CLOB
VARCHAR   (NVARCHAR will do??)
TEXT  (NTEXTwill do??)
BLOB

and, does CHAR/CLOB/VARCHAR/TEXT/BLOB all support size definition? let's say
CHAR(50), VARCHAR(100), TEXT(200), BLOB(500) etc?


-- 
Regards
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to