Symptoms

Grow up the size column for a SmartObject
 

Diagnoses

Right now we have a smartobject with a column defined with text type. We see in the database the size for this text type is nvarchar(100). We need to grow up this value.
We need to know the best practice:
1. grow up in the database
2. change the type from text to memo


 

Resolution

You'll have to update the table to reflect the properties of the column in question. Flipping the SmartObject field property to memo will allow you to use the create method with 65k characters, but the actual input into the database will only be the 100 that you currently have it set too. Thus flipping the property to 'memo' on the SmartObject side will not help at all.