none
What is the max limit for number of characters in multiline text in Sharepoint?

    Question

  • Hi,

    In Sharepoint list, i have a column define as multiline text.  I want to know, what is the max character limit in multiline text, and how can I increase it to unlimited text?

    Thanks any help.

    Abhijit Sil
    Monday, October 18, 2010 4:00 PM

Answers

  • Document libraries and lists have different options available w.r.t to the multiple lines of text column type. In document libraries, when you create a new column of type Multiple Lines of Text, you get the option to select the ‘Allow unlimited length in document libraries’ checkbox. 

    But, In lists, this option does not exist. 

    A multi line text field is defined in sharepoint as a 'Note' type, this is stored in the the DB as a ntext sql type.In the SQL type can store 2gb of char data, that's 1,073,741,823 characters.

    Also, it is not advisavle to store such huge data in sharepoint column as it may hamper performance.
    • Marked as answer by Peng Lei Monday, October 25, 2010 8:54 AM
    • Edited by Mike Walsh FIN Monday, November 29, 2010 2:40 PM sig removed - don't ask people to mark posts
    Monday, October 18, 2010 5:09 PM

All replies

  • Document libraries and lists have different options available w.r.t to the multiple lines of text column type. In document libraries, when you create a new column of type Multiple Lines of Text, you get the option to select the ‘Allow unlimited length in document libraries’ checkbox. 

    But, In lists, this option does not exist. 

    A multi line text field is defined in sharepoint as a 'Note' type, this is stored in the the DB as a ntext sql type.In the SQL type can store 2gb of char data, that's 1,073,741,823 characters.

    Also, it is not advisavle to store such huge data in sharepoint column as it may hamper performance.
    • Marked as answer by Peng Lei Monday, October 25, 2010 8:54 AM
    • Edited by Mike Walsh FIN Monday, November 29, 2010 2:40 PM sig removed - don't ask people to mark posts
    Monday, October 18, 2010 5:09 PM
  • Thanks Dhiren,

    I have created and added a multiline text column in custom SharePoint List.

    Does this column can store 2gb of char data, please advice.

    Thanks


    Abhijit Sil
    Monday, October 18, 2010 5:15 PM
    • Edited by Mike Walsh FIN Wednesday, November 03, 2010 1:00 PM sig removed - don't ask people to mark your posts
    Friday, October 22, 2010 6:20 AM
  • Hi, just wondering if anyone was able to follow up with this question?

    so what about lists? i understand the unlimited option exists fro doc libraries

    so how do we deal with multi text columns in lists?

    any advices will be greatly appreciated.

     

    Thank you,

     

    JK

    Monday, November 08, 2010 4:26 PM
  • Hi JK,

    Yes, multiline text column in list also can store 2gb of char data.


    Abhijit Sil
    • Proposed as answer by Nikhil Phatak Friday, October 18, 2013 7:15 PM
    Monday, November 08, 2010 4:28 PM
  • Is this limit also what cuts off lookups in SPD workflow emails, to 250-255 characters, even though you may have set unlimited in the document/form Library?

    I have a problem where the lookup in a resultant email, from a SharePoint Designer 2007 Workflow will not show all the data that is in the Document Library in that field, and abrubtly cuts of the field displayed in the email.

    Thursday, September 20, 2012 6:49 PM
  • Anybody who needs to know this limit please refer to http://technet.microsoft.com/en-us/library/cc262787.aspx#Column

    Cheers,


    A.galan

    Thursday, January 10, 2013 6:59 PM