Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

size limit of SPList "Multiple lines of text"?

  Asked By: Evelyn Little         Date: Nov 22, 2006      Category: Sharepoint      Views: 1915
 

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

Tagged:              

 

4 Answers Found

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

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

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

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

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

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, 2006       

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].