Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SharePoint: What is the max size of the multi line text field? Can I set it?

Tags:

sharepoint

What is the max size of the multi line text field? Can I set it?

like image 361
vitule Avatar asked Nov 21 '08 15:11

vitule


People also ask

What is multiple lines of text in SharePoint?

A Multiple lines of text column can store up to 63,999 characters, and you can specify the number of lines of text that you want to display when people enter information about an item. This type of column displays all the text when the column is viewed in a list or library.

Is there a character limit in SharePoint list?

According to my research, the Hyperlink column in a SharePoint list or library have a 255 character limit. You can create a Multi-lines of Text column to solve this problem.

Is there a column limit in SharePoint?

Column limits Each column type has a size value listed in bytes. The sum of all columns in a SharePoint list cannot exceed 8,000 bytes.

What is multiline text field?

A multline text input field stores a string as its value and a string as its text. Its value is always a valid string, while its text could be any string entered into its editor. Unlike a text input field, this field also supports newline characters entered in the editor.


1 Answers

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.

Obviously there are practical limits on how big this data should be allowed to get - as SP is a web based system, you do not want to be passing 2gb back and forth all the time.

You can't set it, but you could use a workflow to check the size of the data in the fields and ether truncate or warn about the size of the field.

like image 68
Mesh Avatar answered Oct 05 '22 10:10

Mesh