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.
String or binary data would be truncated when Upgrading Umbraco
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
is working on a reply...