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.