sqlite3 select of BIGINT returns engineering representation sqlite3 select of BIGINT returns engineering representation sqlite sqlite

sqlite3 select of BIGINT returns engineering representation


SQLite's largest data type is signed 64-bit integer, or floating-point.

If you want to store larger numbers exactly, you have to store them as strings.


or cast to long upon poking into sqlite, and back to uint_64 when reading. This avoids sqlite's conversion to a floating point number for large unsigned numbers.