Large integers
Posted: 17.10.2008, 17:33
Hello,
First and foremost, I love SQlite admin. It's easy to use, fast, flexible, all around super.
But I have one gripe with large integers. I have a table where a column is defined as INTEGER, with values of 13 digits (I imagine stored on 6 bytes, which should be OK according to http://www.sqlite.org/datatype3.html). These are timestamps calculated in microseconds from 1800-01-01 00:00:00 (a bit like UNIX time but with a different 0 day). All straight queries of those columns returns 0. Where clauses think this column is always 0 when used in a comparison. The only way I can have it show correctly is by modifying the value, say multiply it by 1. The sqlite3.dll and sqlite3.exe do not show 0, they show the correct value.
Just wanted to bring this to your attention.
Regards.
First and foremost, I love SQlite admin. It's easy to use, fast, flexible, all around super.
But I have one gripe with large integers. I have a table where a column is defined as INTEGER, with values of 13 digits (I imagine stored on 6 bytes, which should be OK according to http://www.sqlite.org/datatype3.html). These are timestamps calculated in microseconds from 1800-01-01 00:00:00 (a bit like UNIX time but with a different 0 day). All straight queries of those columns returns 0. Where clauses think this column is always 0 when used in a comparison. The only way I can have it show correctly is by modifying the value, say multiply it by 1. The sqlite3.dll and sqlite3.exe do not show 0, they show the correct value.
Just wanted to bring this to your attention.
Regards.