search a foreign character in access database using C# -


i have access database contains foreign characters(hebrew language).

how can search values in column using c#? code:

select * "table name" column_name '%שגל%' 

i'm getting error:

syntax error in sql statement

can please afford time , me in this?

שגל- hebrew language.

i fixed bug. changed column name _region property_region.

why _region makes error, keyword

thanks ur answer rik, how specify codepage access


Comments