How large of an Integer can an Integer field hold? Is it a smallint, int, or bigint?
Like
3 comments
21:18 Jan 30, 2020
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.
21:39 Jan 30, 2020
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
21:59 Jan 30, 2020
Add comment
Oscar Dylan, Ryan Farley,
Thanks. I've changed my field to String since the values are out of range.
Show all comments