Hi

I wanted to be able to search for accented words by entering the words without the accents. My textbase is set to accent insensitive, and I've set IgnoreAccents=1 in my inmagic.ini file. I can now find words with an accent on top (for example, I can find Frédéric by searching for Frederic) but I still cannot find François by searching for Francois. Is this expected behavior?

I notice that my SQL Server default collation is accent sensitive, but in my inmcsrv.ini file I have it set to accent insensitive. Do I need to change my SQL Server default collation? How do I do that?

Thanks so much, I always get great help here.

The SQL Server seems to think that c and cedilla-c (ç) are not equivalent, even when using an accent-insensitive collation. Perhaps the cedilla diacritic isn't considered an "accent". If you enter records with the following 4 values:

François
Francois
Frédéric
Frederic


Then look in the Query Choices Browser, Frederic and Frédéric appear as the same key. But François and Francois appear as separate keys.

This is controlled by the SQL collation. I don't know of one that treats c and ç as equivalent. If you find one, you would need to change the SQLCollation= in your INMCSRV.INI file, then use Recover Textbase.

There's no need to change your SQL Server's default collation.