"????" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
Define "really support". SQLite will accept an arbitrary identifier for the column type, as in create table mytable (field XYZZY); > and, does CHAR/CLOB/VARCHAR/TEXT/BLOB all support size definition? Yes. And so does XYZZY. It doesn't do anything though - it's parsed and promptly ignored. create table mytable2 (field XYZZY(50) ); Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

