search a foreign character in access database using C#
I have an Access database that contains foreign characters(Hebrew language).
How 开发者_如何学JAVAcan I search the values in the column 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.
I fixed the bug. I changed the column name from _region to property_region.
Why _region makes error, Is it a Keyword
Thanks for ur answer Rik, How to specify the Codepage for access
Did you specify the codepage for the access database?
http://office.microsoft.com/en-us/access-help/about-the-hebrew-code-page-HP005257928.aspx
精彩评论