Click here to Skip to main content
15,887,477 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
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
Posted

1 solution

what collation are you using in your database? if I'm not mistaken the collation to make it insensitive to accents Latin1_General_CI_AI_KS, this collation is CI = Casi Insensitive, AI = Accent Insensitive and KS = Kana Sensitive.
If your DB is not insensitive you will need to change the collation
 
Share this answer
 
Comments
Alejandro Muñoz Solano 3-Mar-11 15:03pm    
I'm not using database as such (sql server or anything like that), but rather to the index server, how it's done in the index server?, I searched through many pages but no talk about me ...
Gonzoox 4-Mar-11 9:09am    
I see your problem, thought it was SQL Server, anywho, I've not used Index server before, but I have an interesting article that might help you understand better
http://policies.ucsf.edu/query/ixqlang.htm

I read it quickly, and found something about a NEAR operator... probably that is what you need, good luck
Alejandro Muñoz Solano 4-Mar-11 16:37pm    
Well unfortunately the "near" does not help, as it is for something else :(

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900