I have a “number”-type thing.
The number I would like to save in the database for this is 990858419013566485.
However, for some reason, the datebase automatically rounds the last 3 digits (485) to 500 every time I try to save the number. Instead of saving 990858419013566485, its saving it as 990858419013566500.
I did some testing with the last 3 digits being other numbers and it seems that it keeps rounding the last 3 digits to the nearest ‘100’ no matter what I input. In fact, as soon as there are around 16 digits, the last 1-3 digits start getting rounded up or down or even just changing randomly.
Is this a bug? Is there a way to fix the issue?