How do i perform an arabic search in SQL Server ignoring diacritics?
Posted on 2008-06-22
I have SQL Server 2005 and using a database with arabic collation. Certain fields have english and others have arabic (there are no mixed languages, strictly one language per column).
In the arabic field I would like to store words with diacritics. So for those who know arabic, instead of storing #-E/ I will store #N-REN/Q . For those who know english, perhaps the closest example is instead of storing Pierre in the database, I will stored PieNrre (perhaps not correct, but you get the idea).
So my question how do i do an SQL search that will exclude diacretics? Perhaps in a Web form my user will type in a search for '#-E/', however SELECT * FROM tableName WHERE word LIKE '%#-E/%' doesn't work.
I have been searching around the web but can't really get a head start on this.