While I didn't test it on my system, it doesn't surprise me that
nvarchar(255) doesn't work but nvarchar(254) does. I've used
nvarchar(254) as a standard for years. Excel had a limit of 255
characters for years. It usually has something to do with character(s)
that delimit the end of the line.