Question
What is the maximum length of the WebCenter fields?
Reasons you should know this are:
- Maximum length to be expected in reports or other types of reports (for example, returns from the SDK).
- Maximum you can provide to WebCenter via SDK without risking errors or cut-offs.
Answer
The following table gives an overview of the maximum sizes of some of the common fields in the WebCenter.
A Unicode character can represent a single letter in any language (1 byte or 2 byte character sets). So 256 unicode characters means it can contain 256 letters in English but also in Chinese.
The database fields given below are for reference only. It is NOT the intention that you interact with the database directly.
| Field | Maximum number of characters | Database field |
|---|---|---|
| Document Name | 256 Unicode characters | webcenter.Documents.DocName |
| Document Description | 256 Unicode characters | webcenter.Documents.Description |
| Document Version Comment | 256 Unicode characters | webcenter.Doc_Version.Comments |
| Annotation Text | 512 Unicode characters | webcenter.annotation_comment.Annotation_Text |
| External Web Connection Name | 256 Unicode characters | webcenter.ExternalWeb_Configuration.Name |
| External Web Connection Url | 512 Unicode characters | webcenter.ExternalWeb_Configuration.Url |
| Group Name | 25 Unicode characters | webcenter.Groups.GroupName |
| Company Name | 120 Unicode characters | webcenter.Companies.CompanyName |
| Company Legal Name | 120 Unicode characters | webcenter.Companies.CompanyLegalName |
| Company Location Name | 120 Unicode characters | webcenter.Locations.LocationName |
| Company Location Address Line | 250 Unicode characters | webcenter.Locations.Addr1 |
| Company Location City | 50 Unicode characters | webcenter.Locations.City |
| Company Location Zip | 20 Unicode characters | webcenter.Locations.Zip |
| Company Location State | 40 Unicode characters | webcenter.Locations.LocationState |
| Company Location Country | 50 Unicode characters | webcenter.Locations.Country |
| Company Location Phone | 50 Unicode characters | webcenter.Locations.Phone |
| Company Location Fax | 50 Unicode characters | webcenter.Locations.Fax |
| Company Location Shortname | 50 Unicode characters | webcenter.Locations.LocationShortname |
| Menu Name | 256 Unicode characters | webcenter.Menus.Menu_Name |
| Menu Description | 512 Unicode characters | webcenter.Menus.Menu_Description |
| Project Folder Name | 50 Unicode characters | webcenter.Project_Folder.FolderName |
| Project Folder Description | 256 Unicode characters | webcenter.Project_Folder.Description |
| Project Task Name | 250 Unicode characters | webcenter.PROJECT_WCTasks.Task_Name |
| Project Task Description | 800 Unicode characters | webcenter.PROJECT_WCTasks.Task_Description |
| Project Name | 700 Unicode characters | webcenter.Projects.ProjectName |
| Project Description | 700 Unicode characters | webcenter.Projects.Description |
| Project Custom Autonaming Suffix | 250 Unicode characters | webcenter.Projects.AutoName_Suffix |
| Project Custom Autonaming Prefix | 250 Unicode characters | webcenter.Projects.AutoName_Prefix |
| Approval Comment | 512 Unicode characters | webcenter.Submitted_Approval_Status.Approval_Comment |
| Approval Stage Name | 50 Unicode characters | webcenter.docVersion_approval_info.Stage_Name |
Username | 500 Unicode characters | webcenter.users.UserName |
| User First Name | 50 Unicode characters | webcenter.users.FirstName |
| User Last Name | 50 Unicode characters | webcenter.users.LastName |
| User Email | 128 Unicode characters | webcenter.users.Email |
| User Phone | 50 Unicode characters | webcenter.users.PhoneNumber |
| User Mobile | 50 Unicode characters | webcenter.users.MobileNumber |
| Report Name | 400 Unicode characters | webcenter.WC_Reports.Report_Name |
| Report Description | 800 Unicode characters | webcenter.WC_Reports.Report_description |
| Report Output File Name | 256 Unicode characters | webcenter.WC_Reports_Output_Setup.File_Name |
| Task Type Name | 250 Unicode characters | webcenter.WCTask_type.Type_Name |
| Task Type Description | 800 Unicode characters | webcenter.WCTask_type.Description |
| Task Type Default Document Folder | 50 Unicode characters | webcenter.WCTask_type.def_doc_foldername |
| Task Checklist Item Name | 255 Unicode characters | webcenter.WCTask_Type_Checklist |
| Attribute Name | 40 Unicode characters | webcenter.Attributes.AttributeName |
| Attribute Description | 250 Unicode characters | webcenter.Attributes.Description |
| Attributes: Simple Text | 255 - See also | |
| Attributes:Multi-value simple text | Multi-value is encoded as value1 | value 2 | value 3 | ... This sum is limited to 255 characters See also | |
| Attributes: Rich Text | No practical limitation | |
| Attributes: other types | There is always sufficient space foreseen for the type, so no practical limitation | |
| Task specifications | Same limitations as attributes of the same type |
Attribute sizes in WebCenter 12.1.2 and beyond
In version 12.1.2 and newer (including 14), attributes will no longer be restricted in length in any practical matter. This will be especially interesting for multi-value attributes.
| Article information | |
|---|---|
| Applies to | WebCenter all versions |
| Created | 13-Nov-13 |
| Last revised | |
| Author | HADW, KADA |
| CW Number | |
Contents
Overview
Content Tools
ThemeBuilder
Tasks
Bookmarks
1 Comment
Thomas Elton
I've noticed the Job Name fields in AE12.1.1 are truncated when a WebCenter12.1.1 project name is too long. This tends to cause issues when publishing files to projects with long names.
To avoid this I use a SQL query to grab the WebCenter project name from the project ID (from WebCenter DB), then use this SmartName in the Project name field of any publish tasks.
Works a treat!