MS SQL Server Can't Search Some Letters (ı,İ,Ö,Ü,Ğ;Ş...........)

Some languages have different letters than English. While searching you may have  issues, cuz of that.
Here is the solution,

Go to the column you have proglem with it, right-click it and select Modify.

 

Right under column you see Column Properties. Go to Collation.

Pick the language that you want. Click OK and Save your table.