Hi I have a access database that contains foreign characters(Hebrew language).
How can i search the values in the column by using c#?
This is my code:

SELECT * FROM "table name" WHERE column_name LIKE '%שגל%'

I'm getting this error: Syntax Error in SQl statement

Can anyone please afford your time and help me in this?
שגל- this is the Hebrew language.