sqlquantumleap.com
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”)
Microsoft says string literals not prefixed with “N” are converted to the Code Page of the Database OR referenced column. Is that true?