I've indexed documents in Arabic that contain accents (or diacritics) and I want to be able to conduct searches where the query does contain the accents but returns results for texts that both contain and do not contain accents. For example, if I have a
document that contains the word "????????????"
(a word with accents), I would like to be able to search using the word "???????" (the same word without accents).
I have tried several combinations of configurations in my environment to no avail. I have tried installing my SQL Server using Arabic collation and I have installed the Arabic language pack on my OS. I have also tested the same thing with French, and
it is working properly. The spsearchdiacriticsensitive value is set to false (the default).
Does anyone know how to get this working? Is it even possible to do accent-insensitive search with Arabic?
More on my environment:
MOSS 2007 Enterprise
Windows 2008 R2
SQL Server 2008 R2
View Complete Post