Unicode casting language errors

There are some errors that we get when casting unicode string to not-unicode, or vice versa.

Examples:

• Casting from nvarchar to varchar, char to nchar, etc.
• Filter unicode text (string in any not-English language) in not-unicode columns.

In most of the cases, to fix those errors it's enough to add N before the string (in order to make it unicode) or to fix in the stored code the casting (if in the code a parameter is define as varchar when the relevant column is nvarchar - fix the parameter declaration).