Data Type for text longer than 254 chars
Comments
-
0
-
0
-
When using a User Defined Folder Entity Data Structure, how can a text field be created that supports more than 254 characters?
Some observations/questions:
In Decisions, field is set to String [Text]--Notice that the SQL field is set to nvarchar 254 I manually/directly edited the sql column for the user defined entity to nvarchar MAX Seemingly—overnight—the larger text stored in this field was cut down to 254---is some nightly process running that would do this? Unsure what is causing this. I am viewing with a Decisions form. Reports, specifically Rich Text View, limits to 254 displayed regardless of what is in the field
What would be the proper way to support an Entity with a nvarchar field that is greater than 254 chars? Can Rich Text Views support more than 254 character display?
Thanks,
862 -
Hey,
You need to edit this type, select the string datamember at issue, and override the text field storage to set it to max.
The proper way would be to go through the Decisions Studio and update your defined data structure.
String field types have an Override Text Field Storage setting you can set to Max.
Rich Text Displays can hold more than 254 characters. The problem was your entire string was never stored in the database. When you were seeing the entire string, it was only in temporary memory. Once this goes away, we fetch the whatever string is saved in the database. Increasing your Text Field Storage setting will set the field in SQL to nvarchar MAX and resolve your issue saving strings going forward.
Thanks,
863