sqlite> create table numbers (val int); sqlite> insert into numbers values (7); sqlite> insert into numbers values (8); sqlite> insert into numbers

sqlite> create table numbers (val int); sqlite> insert into numbers values (7); sqlite> insert into numbers values (8); sqlite> insert into numbers values (9); sqlite> insert into numbers values ("hi mom, I'm a number!"); sqlite> select * from numbers; 7 8 9 hi mom, I'm a number! I agree that SQLite is great, but do you really want to standardize on that behavior? People will write applications that insert 41 characters into a varchar(40). And they will care when their sites break when constraints start to be enforced.