Linked Questions

Popular Questions

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?

Related Questions