# String or binary data would be truncated when Upgrading Umbraco

**URL:** <https://forum.umbraco.com/t/string-or-binary-data-would-be-truncated-when-upgrading-umbraco/2442>\
**Category:** Questions\
**Created:** [May 11, 2022, 7:56pm UTC](https://forum.umbraco.com/t/string-or-binary-data-would-be-truncated-when-upgrading-umbraco/2442 "2022-05-11T19:56:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://forum.umbraco.com/uploads/default/original/1X/624adeddd330a3d0268a184db47946ca7e82c676.png) [@system](https://forum.umbraco.com/u/system)\
**Post date:** [May 11, 2022, 7:56pm UTC](https://forum.umbraco.com/t/string-or-binary-data-would-be-truncated-when-upgrading-umbraco/2442/1 "2022-05-11T19:56:38Z")

</div>

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](https://our.umbraco.com/forum/108995-string-or-binary-data-would-be-truncated-when-upgrading-umbraco)

---

<div class="post-metadata">

**Author:** ![marciogoularte](https://forum.umbraco.com/user_avatar/forum.umbraco.com/marciogoularte/32/396_2.png) [@marciogoularte](https://forum.umbraco.com/u/marciogoularte)\
**Post date:** [April 4, 2025, 5:48am UTC](https://forum.umbraco.com/t/string-or-binary-data-would-be-truncated-when-upgrading-umbraco/2442/2 "2025-04-04T05:48:02Z")

</div>

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

```auto
ALTER TABLE [dbo].[umbracoPropertyData]
ALTER COLUMN [varcharValue] [nvarchar](max) NULL;

```

---

<div class="post-metadata">

**Author:** ![system](https://forum.umbraco.com/uploads/default/original/1X/624adeddd330a3d0268a184db47946ca7e82c676.png) [@system](https://forum.umbraco.com/u/system)\
**Post date:** [April 4, 2025, 5:48am UTC](https://forum.umbraco.com/t/string-or-binary-data-would-be-truncated-when-upgrading-umbraco/2442/3 "2025-04-04T05:48:03Z")

</div>

Listed on April 4, 2025, 5:48am UTC