Member Avatar for samueal

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
  • 108 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by samueal
Member Avatar for samueal

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

Why _region makes error, Is it a Keyword

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.