Re: [sqlite] INT and INTEGER are not same, behaves differently (for PRIMARY KEY) ?

Am 12.07.2006 um 11:16 schrieb RohitPatel: INT and INTEGER behaves differently (for PRIMARY KEY) !!! (SQLite 3.3.4) create table t1 ( id INTEGER PRIMARY KEY ); create table t2 ( id INT PRIMARY KEY ); insert into t1 values(NULL); insert into t1 values(NULL); insert into t2 values(NULL);

[sqlite] INT and INTEGER are not same, behaves differently (for PRIMARY KEY) ?

INT and INTEGER behaves differently (for PRIMARY KEY) !!! (SQLite 3.3.4) create table t1 ( id INTEGER PRIMARY KEY ); create table t2 ( id INT PRIMARY KEY ); insert into t1 values(NULL); insert into t1 values(NULL); insert into t2 values(NULL); insert into t2 values(NULL); /* insert into t1