I’m trying to create a field with large numbers, but when I put the values into the database, they simply change. Why? Did I enable something wrong?
Remember that this database and workspace are brand new!
There’s nothing in them, no scripts, nothing!
If the field is an integer (zero decimal places) then the max number is about 4.3 billion (2^32-1).
Anything higher will result in an overflow.
If you need higher values, you’ll have to switch it to a decimal field type.
That’s too bad then!
This is an identification number, so I can’t use decimals in it, that would make things way too complicated!
So I’d rather use the field as Text and convert the value to an integer (if possible).
You can definitely store it as text (which makes sense if it is merely an identifier, and not a nunber for which mathematical calculations are relevant) but there is currently no way to convert text to a number.