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