String or binary data would be truncated when saving property editor data using Umbraco.Plain.Json

[skttl (Søren Kottal)]

I’m building a custom property editor, that should save a somewhat large json object (not block list large though).

But when saving nodes using that property editor, it fails with the message String or binary data would be truncated in table '...\UMBRACO.MDF.dbo.umbracoPropertyData', column 'varcharValue'

My manifest looks like this:

        type: 'propertyEditorUi',
        alias: 'MyProject.PropertyEditorUi.RecurringDates',
        name: 'Recurring Dates Property Editor UI',
        element: () => import('./recurring-dates.element.js'),
        elementName: 'recurring-dates',
        meta: {
            propertyEditorSchemaAlias: 'Umbraco.Plain.Json',
            label: 'Recurring Dates',
            group: 'Custom',
            icon: 'icon-custom'
        },

I’ve also tried adding a DataEditor class like the following and set MyProject.RecurringDates as the schema. But no luck:

using Umbraco.Cms.Core.PropertyEditors;

namespace MyProject.Web.Backoffice.PropertyEditors;

[DataEditor("MyProject.RecurringDates", ValueType = ValueTypes.Json)]
public class RecurringDatesDataEditor : DataEditor
{
    public RecurringDatesDataEditor(IDataValueEditorFactory dataValueEditorFactory)
        : base(dataValueEditorFactory) { }
}

I have tried re-saving the data type after changing the schema too.

Shouldn’t Umbraco.Plain.Json and ValueTypes.Json be able to save a json blob?

[skttl (Søren Kottal)]

Weirdly enough… it works today…