What is the max limit for number of characters in multiline text in Sharepoint?
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
October 18th, 2010 12:00pm
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.
October 18th, 2010 1:09pm
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. ThanksAbhijit Sil
October 18th, 2010 1:15pm
You can check the link http://blog.qumsieh.ca/2008/04/11/multiple-lines-of-text-character-limit/
October 22nd, 2010 2:20am
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
November 8th, 2010 11:26am
Hi JK, Yes, multiline text column in list also can store 2gb of char data.Abhijit Sil
November 8th, 2010 11:28am
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.
September 20th, 2012 2:49pm