sections in the article
Question
What Is the Max Amount of Numbers Allowed in a Field with Field Type Double, Integer?
Answer
These are standard definitions for these types of fields.
Integer has a maximum value of 2,147,483,647 (and down to negative -2,147,483,647).
A double can handle values up to 1.8 × 10^308.
Warning: When setting a value for a field of type double through the Remoting API.
Values with large exponents are not handled by the system, which can lead to unexpected errors in the WebPortal. inriver is aware of this matter and is working to resolve it.
Comments
1 comment
In here it is mentioned that Double data type can support 1.8 × 10^308. Yet when you update a large value from the UI, this breaks it completely (as mentioned in the warning). The details tab of the entity no longer opens and you are forced to clear it through e.g. Excel import.
In my case, I had simply put a value 2.42133212212132E+29, which is well within the specification. Then looking at the error inriver logged after putting the value and trying to load the entity:
Which raises the question: why are you trying to convert Double to a Decimal, when C# Decimal can only support a maximum value of 79,228,162,514,264,337,593,543,950,335 instead of the 1.8 × 10^308?
Why is this not mentioned in this article? From the default implementation perspective, the value 79,228,162,514,264,337,593,543,950,335 is your limit, not 1.8 × 10^308.
Please sign in to leave a comment.