Full Text index (catalog accent sensitive problems)

Calagurris2001

I have a Windows 2000 Server with Microsoft SQL Server 2000.

I have a Modern Spanish AI CI database, and we can work with the index in this form. The catalog is well formed (spanish...) but i can't obtain Accent Insentive response with the full text index query.

SELECT *
FROM News
WHERE CONTAINS(*, 'camion')

With this form i can't obtein headlines with the "camión" spanish word.

If i do the normal query

SELECT *
FROM News
WHERE (titulo LIKE '%camión%')

i obtein the Accent Insentive response with the "camión" spanish word.

Can anybody hep me about this problem?????

Thanks from Spain.

2lazybutsmart

Have u tried using Unicode characters?