How can I search a foreign character in access database using C#

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • samueal
    New Member
    • Apr 2011
    • 8

    How can I search a foreign character in access database using C#

    Hi I have a access database that contains foreign characters(Hebr ew 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.
  • samueal
    New Member
    • Apr 2011
    • 8

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

    Why _region makes error, Is it a Keyword

    Comment

    Working...