In this blog post, let’s learn about the error message “4189 – Cannot convert to text/ntext or collate to ‘%.*ls’ because these legacy LOB types do not support UTF-8 or UTF-16 encodings. Use types varchar(max), nvarchar(max) or a collation which does not have the _SC or _UTF8 flags.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
4189 – Cannot convert to text/ntext or collate to ‘%.*ls’ because these legacy LOB types do not support UTF-8 or UTF-16 encodings. Use types varchar(max), nvarchar(max) or a collation which does not have the _SC or _UTF8 flags.
Reason for the Error
To be update soon…
Solution
To be update soon…