In SQL, when dealing with Unicode data, use the right data types like NVARCHAR or NCHAR. To insert Unicode data, add an N before strings like N'' to indicate it's Unicode.

I use accent insensitive queries to DB and this is important for me to match .Net strings as unicode strings in MS SQL Server. In fact .Net String type is Unicode string and for CONTAINS SQL clause it ...

PR #4667 "fixed" issue #4622 by making all string literals Unicode in our SQL generation. But it has been claimed that SQL Server cannot leverage indexes when comparing a Unicode literal or parameter ...