I developed a report in ASP.NET using SQL server. But search text is in greek language. How can I search the name saved in greek language.

See more:

SQL-Server

on my website, i developed a report of sales, customers names are saved in greek in sql server db. my insert query save the record successfully. but when i run query like

SELECT * FROM Customers WHERE name like '%ΤΣΑΓΑΝ%'

It did not return any result, my question is that, i want to search greek text saved in db in sql. what should i do. i googled too much from 2 weeks. but did not found any working solution. may be there is a issue in writing my query. plz help me to solve this.


Thanks in advance

What I have tried:

I tried COLLATE Greek_CS_AS ,freetext etc ,many options, but no one method worked.