SQL query in C# not support Hebrew

Question

I have a problem when I do a SQL query with Hebrew:

"select ProductName From Products WHERE TypeOfProduct ='מעבד'"

I have TypeOfProduct set, that's have the value 'מעבד', but the query returns null.

If I replace the hebrew word in something like numbers or english words, everything goes fine.

How do I use hebrew in SQL queries?

Answer 1

You should use Unicode by using the "N" prefix before the string i.e. N'מעבד' in your where clause...

    select ProductName From Products WHERE TypeOfProduct = N'מעבד'

You also need to make sure that your column is of type nvarchar and not varchar.

If you cannot use nvarchar and Unicode string you will have to change the collation of your database from LATIN to HEBREW.