<lisa@starways.net> wrote in message
news:1150320343.867770.289560@i40g2000cwc.googlegroups.com...
> Forgive me if this has already been asked, but I need to be able to
> search either with accent sensitivity *or* insensitivity, depending on
> user settings or locale.
>
> Is there any way to set up my indexing (either in 2000 or 2005) so that
> I can choose during the search itself whether or not to be sensitive to
> accents? With regular queries, I can use different collations to
> achieve this, but I'm not sure about full text.
>
> Thanks,
> Lisa
>

Hilary Cotter wrote:
> You can't do this in SQL 2000 easily. the only way to do it is through
> thesaurus expansions using FreeText. In SQL 2005 you can create your
> catalogs as accent sensitive or insensitive. Place the table in the accent
> sensitive catalog and an full text indexed view of the same table in the
> accent insensitive catalog.

Hilary Cotter wrote:
> Formsof is not available in SQL 2000, but the thesaurus feature works in SQL
> 2000 FreeText.

<lisa@starways.net> wrote in message
news:1150381512.432132.80410@i40g2000cwc.googlegroups.com...
>
> Hilary Cotter wrote:
>> You can't do this in SQL 2000 easily. the only way to do it is through
>> thesaurus expansions using FreeText. In SQL 2005 you can create your
>> catalogs as accent sensitive or insensitive. Place the table in the
>> accent
>> sensitive catalog and an full text indexed view of the same table in the
>> accent insensitive catalog.
>
> Thanks, Hilary. But I thought the thesaurus expansion with FORMSOF was
> only available starting with 2005. Isn't 2000 limited to inflective
> expansions? If I'm misunderstanding, could you please point me
> somewhere that shows how you'd do thesaurus expansions in 2000?
>
> Thanks again,
> Lisa
>

<lisa@starways.net> wrote in message
news:1150394612.803866.115880@h76g2000cwa.googlegroups.com...
>
> Hilary Cotter wrote:
>> Formsof is not available in SQL 2000, but the thesaurus feature works in
>> SQL
>> 2000 FreeText.
>
> I hear what you're saying, but when I look in the Online Books help
> file for SQL 2000, the FREETEXT predicate says nothing at all about
> thesaurus features. In fact, the word "thesaurus" doesn't appear
> anywhere in that help file.
>
> Do you have any information you could provide about this feature, or
> could you point to a place where such information might be obtained?
>
> Thanks,
> Lisa
>