"Unicode string constants that appear in code executed on the server, such as in stored procedures and triggers, must be preceded by the capital letter N. This is true even if the column being referenced is already defined as Unicode. Without the N prefix, the string is converted to the default code page of the database. This may not recognize certain characters."
E.g.
EXECUTE Product_Info @name = N'Chain'
Link
Server-Side Programming with Unicode[
^]
Submit an article or tip