I know this is an old question. The way I solved it - after failing by increasing the length or even changing to data type text - was creating an XLSX file and importing. It accurately detected the data type instead of setting all columns as
varchar(50). Turns out
nvarchar(255) for that column would have done it too.