Cannot convert to text/ntext or collate to '%1!s!' because these legacy LOB types do not support the Unicode supplementary ...

Cannot convert to text/ntext or collate to '%1!s!' because these legacy LOB types do not support the Unicode supplementary characters whose codepoints are U+10000 or greater. Use types varchar(max), nvarchar(max), or a collation which does not have the _SC flag.