New "nvarchar(max)" Columns Break on Promotion

[JefferyD]

In "Database Maintenance", I added a new column as "nvarchar(max)". It seemed to work fine, but I did notice a difference between existing "nvarchar(max)" columns and the new one I added. The existing ones show "-1" as "MAX LENGTH", while the new one has "max" instead.

image.png (6.56 KiB) Viewed 417 times

image.png (6.56 KiB) Viewed 417 times

After I promoted to QA though, I was getting data truncation error messages. Querying the size of the column, it seems like it was "nvarchar(1)" instead of "nvarchar(-1)".