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 retrieve 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.