Integer length seems to be rounding

Need help Database
1

Hello,
I am trying to store the following number into my app:

8944500408176038470

However, after I save it, it changes to:

8944500408176039000

The field is a Number and I am using Integer in the input content format.

Any idea? Or do I just need to save this as Text?

2

Yes, you can select text (numbers only) on the input’s content format. Not sure why it rounds integers like that…

3

You’re running up against maxint.

4

Yes just save it as text in your database. In the UI you can still use the text input and make the format integer.
As Keith mentioned there is a limit to a number you can use in Javascript so you run the risk of hitting the limit if you’re going to be dealing with such huge numbers. And I’m guessing you’re not even going to be performing any arithmetic operations on this huge numbers so no need storing them as integers.

2 Likes