subject:"\[sqlite\] 8 byte integer not same as MSSQL bigint \-\- missing one value"

Re: [sqlite] 8 byte integer not same as MSSQL bigint -- missing one value

2007-03-07 Thread drh

"Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > Just out of curiosity, why is the range for an 8 byte integer in SQLite one > number off from the 8 byte bigint in MSSQL? > > SQLite: -9223372036854775807 through 9223372036854775807 > MSSQL : -9223372036854775808 through 9223372036854775807 > It

[sqlite] 8 byte integer not same as MSSQL bigint -- missing one value

2007-03-07 Thread Samuel R. Neff

Just out of curiosity, why is the range for an 8 byte integer in SQLite one number off from the 8 byte bigint in MSSQL? SQLite: -9223372036854775807 through 9223372036854775807 MSSQL : -9223372036854775808 through 9223372036854775807 Values are from testing with SQLite 3.3.12 and MSSQL 2005.