Querying Arabic Text

[sulyim]

Hi,
I am using MS Access 2013 as a front end to retrieve data from a database (SQL Server 2008 R2) via (ODBC).
I am using Access forms to insert, update, delete and retrieve data from the database tables in both English and Arabic languages by using datatype (nvarchar) for the text fields.
Everything is going well except filtering Arabic text data. For example; when I try to filter data in the form contains Arabic text like (خدمة), it does not work and it retrieves nothing. The filter works properly for numbers, dates and English texts, but it does not work for Arabic text.

I tried in the query part by creating some queries, for example:
select * from categories where name like '*خدمة *';
Unfortunately, it does not work also.

I appreciate if you can help me to solve this problem.

Sulyim

 

[Guus2005]

Perhaps the query is lost in translation.
Create a pass-through query and try again.

HTH

Weird.... i am sensing a weird feeling of deja-vu. All over again...

 

[sulyim]

The issue of the query has been solved by using passthrough query, but the problem of filtering Arabic word still exists

 

[arnelgp]

maybe you should use arabic office.