New "nvarchar(max)" Columns Break on Promotion
Posted: May 18th, 2023, 2:18 pm
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.
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)".
- image.png (6.56 KiB) Viewed 353 times
- image.png (6.56 KiB) Viewed 353 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)".