Answer the question
In order to leave comments, you need to log in
How to make an entry in sqlite3 an integer instead of 1e+1?
I have a local database
There is a number, a big number!
When it is written to the database, it shows 1e+n (n is just conditional)
To work with it, I use int(float("1e+n"))
Then I subtract a certain value and back to the database (imagine that the number has become less by 1000 )
And then when I need to see what 1e + n shows me there, it turns out that the balance is being restored.
What to do?
I don't want to use a server database in such a small project.
Answer the question
In order to leave comments, you need to log in
How much more is the number? More specific with numbers.
The maximum number that can be stored in integer sqlite (8 bytes) is 9,223,372,036,854,775,807.
If your numbers are larger, then I guess you'll have to store that number as a string or blob.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question