max length of sharepoint list numeric column

Article
2018-02-16

Question

_{Friday, February 16, 2018 9:54 PM}

I want to document for a client max length of sharepoint list numeric column. I do not see any documentation on this....

I do see for single line max length is 256. What about numeric?

MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

All replies (4)

_{Friday, February 16, 2018 11:12 PM}

For a numeric column it would be the max size of a value stored as a double, so its not based on the length of the field. Instead its dependent on how many places to the right of the decimal you want (precision).

Paul Stork SharePoint Server MVP
Owner/Principal Architect: Don't Pa..Panic Consulting
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as 'answered' if this solves your problem.

_{Monday, February 19, 2018 5:40 AM}

Hi,

The maximum value of number column is 550.

Check the following official article to learn more about column limits:

https://technet.microsoft.com/en-us/library/mt493258%28v=office.16%29.aspx?f=255&MSPPError=-2147217396#Column

Best Regards,

Linda Zhang

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

_{Tuesday, February 20, 2018 1:52 PM}

thanks Linda, Paul. Now I need to give client max length(15,20 etc.) how do I convert 550 bytes to length? For single line I know max is 256 char, same is needed as they want to design their column in oracle with max length of our numeric field.

MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

_{Monday, February 26, 2018 2:34 AM}

Hi,

In Oracle, all number types are stored as a length field from 0 to 22 bytes in length. The size per SharePoint Number column is 22 bytes.

You don’t need to design the numeric column size.

Best regards,