If I try to insert data with a 20-bit primary key into the SQLite database, I get an error with the second insert because it is "not unique." If I select the values that I can see from the SQLite command line, that primary key is written in scientific notation. Column type is decimal. Is there a way to force SQLite to insert values “like them” while maintaining accuracy / “normal representation” even with long values?
enter it as a string, not a number.
, - 9223372036854775807. () .
Strange, it sounds like your wrapper, inserting a number into a float. I thought DECIMAL maps to an integer inside. Using a string will work, but can be slow for indexing a string, not for int.