Re: [sqlite] AUTOINCREMENT BIGINT

Ok understand thanks Il 07/11/2014 14.40, Richard Hipp ha scritto: On Fri, Nov 7, 2014 at 8:26 AM, Michele Pradella

Re: [sqlite] AUTOINCREMENT BIGINT

On Fri, Nov 7, 2014 at 8:26 AM, Michele Pradella wrote: > > Is there a way to sue AUTOINCREMENT with BIGINT? what's the reason for > this check? > No. Furthermore, AUTOINCREMENT probably does not do what you think it does. Please read the details at

Re: [sqlite] AUTOINCREMENT BIGINT

Michele Pradella wrote: > I have a question about data type BIGINT BIGINT is not a data type. > from docs (http://www.sqlite.org/datatype3.html) This page says the data types are NULL, INTEGER, REAL, TEXT, and BLOB. > I understand that INTEGER and BIGINT results in the same affinity Yes. >

[sqlite] AUTOINCREMENT BIGINT

Hi all, I have a question about data type BIGINT: from docs (http://www.sqlite.org/datatype3.html) I understand that INTEGER and BIGINT results in the same affinity (INTEGER), so datatypes are same, is it correct? Unfortunately if I create a table with a field "Id BIGINT PRIMARY KEY