Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

size limit of SPList "Multiple lines of text"?

  Asked By: Evelyn    Date: Nov 22    Category: Sharepoint    Views: 6854

Does anyone know the size limit of SPList "Multiple
lines of text"?



4 Answers Found

Answer #1    Answered By: Laura Walker     Answered On: Nov 22

I think if I remember correctly it's around 8192 characters.

Answer #2    Answered By: Cory Brooks     Answered On: Nov 22

13-bit? ?????????????????????????

Answer #3    Answered By: Ruth George     Answered On: Nov 22

8192 (actually something slightly smaller than that) is the maximum length for a record in SQL server and therefore is the maximum length of an individual record in SharePoint. The limit  comes from the fact that SQL uses an 8K page size  and records are not allowed to span pages. However, I believe that multi-line text  fields are stored in TEXT fields. They are just 16 byte pointers to a different page in the database. The result is that it’s not counted in the maximum record length.

Although I’ve not tested to find a practical limit from a SharePoint perspective, I can tell you that technically SQL server supports file sizes up to (I believe) 2GB in TEXT and IMAGE fields. (It may be larger I’ve not looked in a while.)

Answer #4    Answered By: Peter Peterson     Answered On: Nov 22

You must be right. I tried to save about 30K bytes and
it is still fine.

Didn't find what you were looking for? Find more on size limit of SPList "Multiple lines of text"? Or get search suggestion and latest updates.