Iam using sql server 2008 r2 with database that saving Arabic and English with it, when i use this sql statement
SELECT * FROM Land_Files WHERE Briefness LIKE '%Qusin%'
it gives me aresult but when i use the same sql Statment with small difference :
SELECT * FROM Land_Files WHERE Briefness LIKE '%قوصين%'
it does not give any result but I am sure i have the word قوصين in Briefness column.
what is the wrong with searching with arabic??
how can i solve this problem ?