Hi, I have a page done in c #, that page uses index server to search for documents (saved in html). I have a problem with the use of Spanish words in that language there is a tilde (á é í ó ú), but not all people remember that words have accents or not ... That is why for example if a document is the word "árbol" (with accents) but the user types "arbol" (ie without an accent or tilde) ... The result of the search does not return me the results, it searches for exactly the word without accents. How I can do not to import that type with or without accent?
This is my code:
SELECT
FileName,
Path, Rank
FROM
SCOPE('DEEP TRAVERSAL OF("C:\docs\D\1")')
WHERE
CONTAINS(CONTENTS,'"arbol"')
ORDER
BY WRITE DESC