Re: "CONTAINS" ignores "fahrenheit"?
From: John Kane (jt-kane_at_comcast.net)
Date: 08/09/04
- Next message: John Kane: "Re: Error 7619 - Cannot enable FTS on any database"
- Previous message: seeker: "Re: Cannot enable full text indexing"
- In reply to: Danny: "Re: "CONTAINS" ignores "fahrenheit"?"
- Next in thread: DC: "Re: "CONTAINS" ignores "fahrenheit"?"
- Reply: DC: "Re: "CONTAINS" ignores "fahrenheit"?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 8 Aug 2004 21:14:04 -0700
Danny,
To come back to not finding "Fahrenheit 9/11" because this word is in
contact with the html tags <EM> and <\EM>, this is because you are using SQL
Server 2000 on Windows 2000 Server (emphasis on the OS platform) and Shiloh
bug# 351310 "Full Text Search Win2K word breaker does not ignore punctuation
unless separated by white space". This is a known bug with the Windows 2000
Server US_English wordbreaker (infosoft.dll) and can be worked around via
re-setting the "Language for Word Breaker" to Neutral and then running a
Full Population. Note, that when you switch to the Neutral wordbreaker you
will lose some SQL FTS functionality due to the neutral wordbreaker
"breaking" words based upon the white space between words, specifically, you
lose the language-specific inflectional search capability. Also, if you
upgrade to Windows 2003 Server (Win2003) you can avoid this as well as
removing the <EM>, </EM> tags.
Additionally, the issue with finding or not getting error 7619 when
searching on "9/11" is most likely due to OS differences as well as on Win2K
the "9/11" would be indexed as a single token (due to the / "slash"
character in touch with both 9 & 11), while on WinXP or Win2003 with 9
removed from noise.enu (US_English) would return a valid row and not error
7619.
Regards,
John
"Danny" <daniel_c@NOSPAMmyrealbox.com> wrote in message
news:ehzq2vAfEHA.1604@TK2MSFTNGP11.phx.gbl...
>
> "Johnny Nielsen" <DONT.WRITE.THIStrap402@megabit.dk> wrote in message
> news:OgcrPH%23eEHA.1208@TK2MSFTNGP10.phx.gbl...
> > You tell me ;-)
> >
> > Try ...CONTAINS(*,'9') in Query Analyzer and look for the message
> "Execution
> > of a full-text operation failed. A clause of the query contained only
> > ignored words."
> >
> >
> > Best regards
> > Johnny Nielsen
>
> Hmm... it doesn't happen to me. I don't get any message, it works fine.
>
>
>
- Next message: John Kane: "Re: Error 7619 - Cannot enable FTS on any database"
- Previous message: seeker: "Re: Cannot enable full text indexing"
- In reply to: Danny: "Re: "CONTAINS" ignores "fahrenheit"?"
- Next in thread: DC: "Re: "CONTAINS" ignores "fahrenheit"?"
- Reply: DC: "Re: "CONTAINS" ignores "fahrenheit"?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
