Search is not working with Hebrew?

igoro1975 · **Posted:** Sun Aug 27, 2006 1:17 am

I have a very simple line in my project:

Code:

IList list = session.Find("from Sample as s where s.ClientName like '%" + clientName + "%'");

When I am trying to get results and clientName consist of English letters, the search is working beautiful but I get no results with Hebrew letters at all.
How can I solve the issue?
Thank you,
Igor

radu · **Joined:** Wed Jun 15, 2005 4:17 am **Posts:** 156

Check the generated SQL by enabling logging. If you use SQL Server you can use the Profiler as well. If the generated query looks good then is a database issue. Also it is considered good practice to use parameters in your query instead of building it by string concatenation.

HTH,
radu

igoro1975 · **Posted:** Mon Aug 28, 2006 1:26 am

radu wrote:

Check the generated SQL by enabling logging. If you use SQL Server you can use the Profiler as well. If the generated query looks good then is a database issue. Also it is considered good practice to use parameters in your query instead of building it by string concatenation.

HTH,
radu

Thank you, but it was my fault (DB Collation).