I am having the very same problem here. The size of this database field (varchar (255)) is simply not enough when you use custom created text area fields.
I have implemented Jim’s solution and altered database column to varchar (max). Now everything is working properly except that I just lost upgrade safety! And I want to be able to upgrade when needed. And also I have this irritating error every time I do Repair and Rebuild:
[FATAL] Executing repair query: Query Failed:ALTER TABLE fields_meta_data ALTER COLUMN [default_value] nvarchar(255) NULL::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]String or binary data would be truncated.
It is trying to alter field back to nvarchar(255) but fails when squeezing my text into it.
I am not sure if this field should have limited size but 255 is just too small for large text like Terms&Conditions or Warranty options or EULA etc.
I know that this texts could be added as an additional document aside but it is a lot more flexible if someone wants to change some parts of this text.
Use case for custom text area fields bigger than 255 is like when creating Quotes/Contracts with slightly different T&C and you want a user to be able to make this changes easily. The other way around is to make as many templates as you have possible differences in terms but this is not practical or to have as many 255 fields as needed chained one after another instead of one, again not practical.
Is there a way to vote for this change to be implemented in the future releases? Let’s say varchar(2000)…(who really need’s (max))?