Kervin L. Pierre <kervin-3GP3cpDhPzVWk0Htik3J/[EMAIL PROTECTED]> wrote:
I expected this script to work...
create table testtable ( testcol int );
insert into testtable ( testcol ) values ( -2146369472
)
select * from testtable where ( testcol & 4294967295 )
= -2146369472
Note that 4294967295 in binary is
all '1's.
No, it's 32 zeros followed by 32 ones. SQLite deals with 64-bit
integers.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------