Sql Full Text Search accent insensitive

i have sql 2000.

my problem is that accent is sensitive when i use ContainsTable in full text
search.
i like a accent insensitive.

please help me....thank you

stexavcar,

Although the SQL Server has accent insensitive collations, the full-text
engine does not have this component, so names will be accent sensitive.
http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlser....fullte

Back in 2004 (part of the thread above) Hilary Cotter suggested that you
will have to preprocess your query string and include accented and
unaccented versions of the words that you care about.

RLF

"stexavcar" <stexavcar DeleteThis @discussions.microsoft.com> wrote in message
news:F33A466D-466D-454C-8A16-38190C2689E4@microsoft.com...
>i have sql 2000.
>
> my problem is that accent is sensitive when i use ContainsTable in full
> text
> search.
> i like a accent insensitive.
>
> please help me....thank you