On 1/30/2014 7:20 PM, James K. Lowden wrote:
or define a constraintcolname boolean check (colname in ('Y', 'N')) Of course you can use 0 and 1, but there's no technical advantage
There is a tiny advantage. Values 0 and 1 are special-cased in SQLite's file format, and occupy only one byte each. 'Y' and 'N' require two bytes to represent.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
