On Thu, Apr 24, 2014 at 10:23 AM, Igor Tandetnik <i...@tandetnik.org> wrote: > 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') );
Perfect -- thank you for the help :)!!! -Garrett _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
