Multiple Lines of Text Character Limit

I recently attempted to figure out how much data the multiple lines of text column type within MOSS can hold. I came across a few interesting things I thought I’d post about.

  1. Document libraries and lists have different options available in regards to the multiple lines of text column type. Within document libraries, when you create a new column of type Multiple Lines of Text, you have the option to select the ‘Allow unlimited length in document libraries’ checkbox. In lists, this does not exist.
  2. It’s important to note though, that by setting that checkbox to true, you are losing support for other applications that cannot handle data of that size. Microsoft posted some remarks to caution users:

    Columns with long text are not supported by most applications for editing documents and could result in a loss of data. Only allow unlimited length if users will be uploading documents through the Web site, and not saving directly from the application.

    SPFieldLookup.UnlimitedLengthInDocumentLibrary Property

  3. I ran some tests with the multiple lines of text column type for a list and was able to successfully store over 11000 characters. It’s entirely possible that this is a sql limitation. If anyone has any insight into this, please fire me off an email.

4 Responses to “Multiple Lines of Text Character Limit”

  1. Jitendra April 24, 2013 at 7:50 am #

    Hi, I also tried to store the long data in multiline column and i could store only 1025. After that my data got truncated. Let me know if we have any settings which we can activate for List, not library, to reach the max length of 11000, as you mentioned.

  2. shereen April 26, 2013 at 9:11 am #

    Which version of SharePoint?

  3. Ijaz October 30, 2014 at 9:47 am #

    Can you tell what will happen to a doc Lib when I change the setting ? Will it truncate column data when I check the document back into the server ?

  4. Purv Gohel January 8, 2018 at 11:37 am #

    I would like to know how to increase the multiple line of text character limit from 1025 to 2000 ?
    Please suggest me a way to increase this limit.
    Thanks in advance.

Leave a Reply