2

I'm making a list and need to store IP Addresses and Account Numbers.

Basically the text or single line of text variable looks best at the moment however I am wondering if anyone else knows a better way to store them in a SharePoint 2013 list.

I doubt an upgrade to IPv6 will happen, but the 16 places are necessary for the account number size(0123456890123.)

1
  • I found that I was just trying to go out of my way for no reason in storing the list data Commented Jun 15, 2016 at 16:20

1 Answer 1

3

Single line of text can store 255 characters. So you will be good even in case of IPv6.

One drawback of storing interger in text field is that you will lose the out of the box ability to apply mathematical functions like SUM etc.

3
  • 1
    As for performance issues.. You don't have any control over the SQL server database.. Last time I looked was SP2003.. back then everything in the Tables was a (large) String. If you limit your Field in SharePoint it is a SharePoint (UX) limitation only.. Commented Jun 14, 2016 at 15:26
  • I don't understand, so I shouldn't bother with anything but Text field types unless I really have to? Commented Jun 14, 2016 at 19:08
  • 1
    You can store any type of value into a text field. The maximum characters allowed is 255. If if want to store more than 255 character value then use multiline. Commented Jun 14, 2016 at 19:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.