In this blog post, let’s learn about the error message “4188 – Column or parameter ‘%.*ls’ has type ‘%ls’ and collation ‘%.*ls’. The 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
4188 – Column or parameter ‘%.*ls’ has type ‘%ls’ and collation ‘%.*ls’. The 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…