On 4/24/2014 1:03 PM, yaneurabeya . wrote:
Being able to INSERT and print out 'a' above caught me off guard a bit.
Is this programmer error when I ran CREATE TABLE or the INSERT
(this is the most likely answer, but I wanted to be sure), or is this
by design?
By design. For details, see http://www.sqlite.org/datatype3.html . If
you want strict typing, you can request it with a CHECK constraint:
CREATE TABLE bar2(foo INTEGER CHECK (typeof(foo)='integer') );
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
