Re: Must a hyphen always be a wordbreaker?
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Mon, 11 Sep 2006 14:11:05 -0400
Microsoft changed the word breaker between versions. I don't know of a way
other than what I have suggested to fix this.
--
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
"mjr111" <mjr111.2dzc9z@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:mjr111.2dzc9z@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Replacing the term 10-23 with 10HYPHEN23 seems a pretty poor work
around. Especially considering it used to work correctly with SQL200
and windows 2000.
Why have MS changed this, or at least when will they accept it is a bug
with windows 2003 and fix it. It seems it's something to do with the OS
and not actually SQL2005.. or some strange combination of both.
The old version worked as you would expect, a term indexed as 143143
could be found by searching for 143-143, or 143143. In other words it
would act as a word 'joiner'. However a term indexed as 21-2100 could
only be found by searching for that.
In terms of grammer and logic the old way makes more sense, a hyphen is
meant to join two works, not break them.
This change has pretty much made SQL server useless for my entire
ecommerce application as part numbers can have hyphens in so if anyone
has any other suggestions i'd love to hear them
--
mjr111
------------------------------------------------------------------------
mjr111's Profile: http://www.dbtalk.net/m819
View this thread: http://www.dbtalk.net/t283344
.
- References:
- Re: Must a hyphen always be a wordbreaker?
- From: mjr111
- Re: Must a hyphen always be a wordbreaker?
- Prev by Date: Re: Performance issue with CONTAINS
- Next by Date: Re: conditionally query a catalogue's field
- Previous by thread: Re: Must a hyphen always be a wordbreaker?
- Index(es):
Relevant Pages
|