String or binary data would be truncated when Upgrading Umbraco

Questions
1

Hi I’m trying to upgrade Umbraco from 7.15.7 to 8.18.3 (as a experiment at this point) and I’m running into the “String or binary data would be truncated” error when doing so. I think I traced it to the cmsPropertyData table’s dataNvarchar column being renamed to varcharValue and it’s data type changed NVARCHAR(512). I base that on reading the log file.

Is it possible to keep the data type of NVARCHAR(max) on that column during the upgrade? I have about 100 entries in that column over 512 characters long.

Any help is appreciated and thanks,

Drew

This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/108995-string-or-binary-data-would-be-truncated-when-upgrading-umbraco
2

I had this problem recently with Umbraco 13. No suffering, no guilt, do this

ALTER TABLE [dbo].[umbracoPropertyData]
ALTER COLUMN [varcharValue] [nvarchar](max) NULL;
1 Like