Re: Problems with CONTAINS

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?


--
Hilary 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



"LeCitadin" <boucher.pierre@xxxxxxxxx> wrote in message
news:1158605251.509317.131840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 ?


.

Relevant Pages

  • SQL 2K : custom word breaker ?
    ... Is it possible to create a custom word breaker for SQLServer fulltext.... ... use french word breaker, but for some specific tables, it's not exactly what ...
    (microsoft.public.sqlserver)
  • SQL 2K : custom word breaker ?
    ... Is it possible to create a custom word breaker for SQLServer fulltext.... ... use french word breaker, but for some specific tables, it's not exactly what ...
    (microsoft.public.sqlserver.fulltext)
Loading