开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜