How large of an Integer can an Integer field hold?  Is it a smallint, int, or bigint?

https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-ver15

Like 0

Like

6 comments

Maximum value integer field can hold is 2147483647 and you can test in on your side as well - the system won't allow you saving numbers greater than 2147483647.

To add to what Oscar said, the SQL database type is int, but the restriction is also due to the .NET datatype in the entity, which is an Int32 (an Int32 has a +/- 2147483647 max size) https://docs.microsoft.com/en-us/dotnet/api/system.int32?view=netframew…

Ryan

Add comment

Oscar Dylan, Ryan Farley,

Thanks.  I've changed my field to String since the values are out of range.

is there any way to accept bigger values? in my case I'm working a project to manage public works, such as roads, dams, stadiums, etc., and the amounts are very large.

Also I saw I can introduce larger decimal values, this have no logic why I can introduce 52.437.560.581,00 and not 52.437.560.581? In the case of customer they didn't use decimals, price of the public works are Integer

Julio.Falcon_Nodos,

this is .Net Framework restriction and Creatio can't really do anything about it. They could only create a long datatype for big integers

Show all comments