Huge (20 digits) Primary keys and SQLite
database, primary-key, sqlite
Solution
insert it as a 'string', not a number.
Problem
If I try to insert data with a 20 digit primary key into a SQLite database I get an error with the second insert statement because it "is not unique". If I select the values I can see from the SQLite commandprompt that the primary key is written in scientific notation. The column type is decimal. Is there a way to force SQLite to insert the values "as they are" keeping the precision / "normal representation" even with values that long?