 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / September 2006Problems with CONTAINS
Hi, I am executing the followings SELECT and the results are not as expected. ====================================== Search 1 SELECT Valeur FROM RechercheChaines WHERE CONTAINS (Valeur, 'HYDRO-QUÉBEC') Valeur -------------------------------------------- BROCHURE HYDRO-QUÉBEC ====================================== Search 2 SELECT Valeur FROM RechercheChaines WHERE Valeur LIKE '%HYDRO-QUÉBEC%' Valeur -------------------------------------------- BROCHURE HYDRO-QUÉBEC BROCHURE PUBLICATION D'HYDRO-QUÉBEC PUBLICATION D'HYDRO-QUÉBEC RAPPORT ANNUEL PUBLICATION D'HYDRO-QUÉBEC RAPPORT PUBLICATION D'HYDRO-QUÉBEC RAPPORT TECHNIQUE PUBLICATION D'HYDRO-QUÉBEC ====================================== As you can see, the two SELECT does not return the same results. The search 2 is the one I was expected in the fulltext search. We are using a french separator file. Any ideas ? I assume you are using the French Word breaker even though you are in Quebec. In this case HYDRO-QUÉBEC will only match with HYDRO-QUÉBEC. If you are using by change the US or UK English word breakers or the neutral word breaker it will match with HYDRO QUÉBEC, HYDRO-QUÉBEC, or HYDRO. QUÉBEC. Does this explain what you are seeing?  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com Hi, I am executing the followings SELECT and the results are not as expected. ====================================== Search 1 SELECT Valeur FROM RechercheChaines WHERE CONTAINS (Valeur, 'HYDRO-QUÉBEC') Valeur -------------------------------------------- BROCHURE HYDRO-QUÉBEC ====================================== Search 2 SELECT Valeur FROM RechercheChaines WHERE Valeur LIKE '%HYDRO-QUÉBEC%' Valeur -------------------------------------------- BROCHURE HYDRO-QUÉBEC BROCHURE PUBLICATION D'HYDRO-QUÉBEC PUBLICATION D'HYDRO-QUÉBEC RAPPORT ANNUEL PUBLICATION D'HYDRO-QUÉBEC RAPPORT PUBLICATION D'HYDRO-QUÉBEC RAPPORT TECHNIQUE PUBLICATION D'HYDRO-QUÉBEC ====================================== As you can see, the two SELECT does not return the same results. The search 2 is the one I was expected in the fulltext search. We are using a french separator file. Any ideas ? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.