0

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.

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by samueal
0

I fixed the bug.
I changed the column name from _region to property_region.

Why _region makes error, Is it a Keyword

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.