Using Arabic text in the where clause of a query – Access

[sulyim]

Hi,
I am using MS Access 2013 as a front end to retrieve data from a database (SQL Server 2008 R2) via (ODBC), and the tables are linked.

I created a query to retrieve all the records in the table (categories) filter records based on an Arabic text in the field (name), for example:

select * from categories where name like '*خدمة *';

This query returns nothing when the table is linked to the SQL server, but when I converted the same table to local table, this query works and returns all the records with that condition.

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