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