I understand that SQLite lets you use arbitrary names for column types, and all that's significant is a few substrings like "INT", "CHAR", and "BLOB". But what's the common practice? Do you declare everything as INTEGER, TEXT, BLOB, REAL, or NUMERIC for a one-to-one match with the actual type affinities? Or do you declare types like DATE, BOOLEAN, VARCHAR(20), SMALLINT, etc.?
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users