I'm trying search in Arabic text in SQL Server and need to ignore the Arabic diacritics.
So I'm using
Arabic_100_CI_AI collation. but it's not work.
For example for the below query I must get 1, but it has no result!
select 1 where (N'مُحَمَّد' Collate Arabic_100_CI_AI) = (N'محمّد' Collate Arabic_100_CI_AI)
What is the problem and how can I perform diacritics insensitive comparison in Arabic text?