Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am using SharePoint List to capture values from the form. How many characters does multiple lines text field supports in sharepoint custom list?

It asks me how many lines, while creating the column. How many character a line can accomodate?

I am using SP 2007.

Thank you

share|improve this question

3 Answers 3

up vote 1 down vote accepted

The multiple lines text field is a ntext SQL type so it can store up to 2 Gb of text.

The characters a line depends how the input or textarea is rendered on your html (how many columns, what size of text, what font-family you use...) or how the user has it configured to render on their screen... so short answer is: "there is no specific length of characters in a line".

share|improve this answer

if I'm not wrong a multi line text field is a 'Note' type, this field mapped to a ntext sql type in DB. In this SQL type you can store

Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. Storage size, in bytes, is two times the number of characters entered. The ISO synonym for ntext is national text.

See more about ntext

share|improve this answer

Practically it can accomadate a very lengthy value which will be sufficient for normal requirements.

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.

Source http://stackoverflow.com/questions/309188/sharepoint-what-is-the-max-size-of-the-multi-line-text-field-can-i-set-it

Since sharepoint is totally based on SQL the limitation of SQL columns maximum length will be the sharepoint column maximum limit.

If you come to sharepoint context, it is number of columns that is based for limitation ,a list can accomodate rather than individual column max limit.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.