I m using Ms-Sql DB and I have a field that is saved in the DB as nvarchar type. I use linq to sql in the following way:
var names = NamesTable.where(n=>n.name.Contains("acções"));
this query returns names containing: acçoes/ accoes or any other combination. it seems that sql doesn t recognize the latin special letters as different from the english ones.
我该如何解决这个问题?