灵感之源 <[EMAIL PROTECTED]> writes: > > 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? >
If you have read (and understood) the documentation link, you will already know the answer - Section 1 says it all - so what is the point of your question ? Or do you want to map fields from another database system ? Regards, MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users