MSSQL+Unicode+CONTAINS: Your Help

Dears... I have one problem here

I have MS SQL 2000 server Unicode database. Characters stored in this database are non-Latin (Arabic) characters. I have enabled the Full-Text Search service and used the CONTAINS function to search the database. Unfortunately, the produced query result is incorrect. It has extra records that are not valid. The word breakers seem to be not appropriately defined such that the records with similar, but not exact, words are listed in the result set. I have tried to set the Language Neutral Full-Text option to 0 and 1. However, undesirable records still appear in the record set.

Looking forward your help?
 
Back
Top