You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in

Explains that you should add a prefix of N before all Unicode strings when you deal with Unicode string constants in SQL Server. ... This notation is necessary to provide backward compatibility with existing applications. For example, "SELECT 'Hello'" mus

support.microsoft.com