多行文本字段

本文介绍了多行文本字段的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在开发一个Excel文件，其文件属性已定义为在SharePoint上链接。该模板在过去的两个季度中运行良好。它在所有90个已定义的属性中包含数字字段/日期字段/文本字段和1个多行文本字段

现在我添加了另外28个多行文本字段，这些字段没有占用值超过255个字符。每当文本值的长度较短时，SharePoint上的值更新就好了。

我已经定义了"允许无限长度"属性的字段，以允许更大的文本。但它不起作用：（

我现在有一个查询，如果定义多行文本字段的数量有限，无限长度。

解决方案

您好，

文档库和列表具有多行文本列类型可用的不同选项。库，当您创建多行文本类型的新列时，您可以选择"允许文档库中的无限长度"复选框。 但是，在列表中，此选项不存在。 $ 多行文本字段在sharepoint中定义为"注释"类型，它作为ntext sql类型存储在DB中。在SQL类型中可以存储2gb的char数据，即1,073,741,823个字符。 此外，它不是可取的将大量数据存储在SharePoint列中，因为它可能会影响性能。

以下是您提交的相同问题ence：

多行文本列中的最大字符数

以下是列表中字段类型的最大数量列表：

单行文字：276 多行文字：192 选择：276 数量：72 货币：72 日期和时间：48 $ 查询：96 是/否：96 人或团体：96 超链接或图片：138 计算：48 GUID：6 Int：96 管理元数据：94

谢谢

最好的问候

Hi,

I am developing an Excel file which has document properties defined to link on SharePoint. the template was working fine for last 2 quarters. it has in all 90 defined properties with numeric fields/date fields/text fields and 1 Multiple Lines of text fields

Now I have added another 28 Multiple lines of text fields, which are not taking values for more than 255 characters. Whenever the text values is of lesser length, the value updates on SharePoint just fine.

I have already defined the fields with 'Allow unlimited length' property ticked to allow bigger text in it. but it's not working :(

I now have a query that if there is a limit on defining the number of Multiple Lines of text fields with unlimited length.

解决方案

Hi,

Document libraries and lists have different options available to the multiple lines of text column type. In document libraries, when you createa 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 advisable to store huge data in SharePoint column as it may hamper performance.

Here is the same question for your reference:

Maximum characters in Multiple lines of text Column

And here is the list of maxium number of field type in a list:

Single line of text: 276 Multiple Lines of Text: 192 Choice: 276 Number: 72 Currency: 72 Date and Time: 48 Lookup: 96 Yes / No: 96 Person or group: 96 Hyperlink or picture: 138 Calculated: 48 GUID: 6 Int: 96 Managed metadata: 94

Thanks

Best Regards