On 4/9/2013 9:15 PM, Simon Slavin wrote:
Wow. I have never seen that before. Or the VARIANT type used in SQLite. Thanks.
VARIANT doesn't have any special meaning to SQLite. You can just as well write "CREATE TABLE t1(c1 foo bar);", and sqlite3_column_decltype would cheerfully return the string "foo bar". The only way the type is used is to determine column affinity, as documented at http://www.sqlite.org/datatype3.html . Both VARIANT and "foo bar" would result in NUMERIC affinity.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
