Re: "CONTAINS" ignores "fahrenheit"?

From: John Kane (jt-kane_at_comcast.net)
Date: 08/05/04 

Date: Wed, 4 Aug 2004 23:16:46 -0700

Hi Danny,
Hmm... that someone would be me? <G>
Ok, you need to provide some additional info, specifically, run and post the
full output of the following SQL script:

use <your_database_name_here>
go
SELECT @@language
SELECT @@version
-- Note, you may need to set advance options on
sp_configure 'default full-text language'
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help tblArticle
go

Depending upon the language (the FULLTEXT_LANGUAGE column from
sp_help_fulltext_columns) of the wordbreaker you are using, have you removed
all single digits from the noise.<language> (noise.enu = US_English) file
under the folder: \FTDATA\SQLServer\Config ? If not, then you should and
then run a Full Population. Note, you will need to stop the "Microsoft
Search" service first in order to save the changes to the noise.* files.

Additionally, the preceding asterisk "*" in your query ' "*9/11*" ' is
always ignored and therefore adds no value to your query. SQL FTS support
only "word prefix" wildcard searches with the asterisk and not "word
suffix", for example ' "*og" ' would find dog and log, but these "words"
are not related. However, using a "word prefix" search such as ' "9/11*" '
returns rows that contain "9/11", or ' "fish*" ' will return "fish",
"fishes" or "fishing" as these words are inflectionally related...

Regards,
John

"Danny" <daniel_c@NOSPAMmyrealbox.com> wrote in message
news:uoE953peEHA.2440@tk2msftngp13.phx.gbl...
> Correction:
>
> > More interesting is if I run this SQL Statement:
> >
> > SELECT *
> > FROM tblArticle
> > WHERE CONTAINS(article_text, ' "*9/11*" ')
> >
> > it returned me records that contains "9/11" but not "Fahrenheit 9/11",
> > for example:
> > it returns -> article_text: ... in 9/11 event...
> > it doesn't return -> article_text: ... Michael Moore who wrote
Fahrenheit
> > 9/11 ...
> >
>
>

Relevant Pages

  • Re: C# is ignored on 2000 Server in mssearch
    ... SQL Server version, language as well as OS ... Could post the output of the following sql script on the server ... EXEC sp_help_fulltext_catalogs ...
    (microsoft.public.sqlserver.fulltext)
  • Re: UserLinux chooses Python as "interpretive language" of choice
    ... This style, while adequate for simple commands, proved cumbersome ... written in EXEC 2. ... It became clear to me that a new language was ... the command and string programming facilities that EXEC 2 had proven to ...
    (comp.lang.python)
  • Re: REXX error
    ... Place cursor on choice and press enter to Retrieve command ... => exec 'adcds.clist.library' ... Neither of these requires a leading language indicator in z/OS. ...
    (bit.listserv.ibm-main)
  • Re: Error on Full-Text
    ... Could you provide the exact SQL query code that exceeds 8k ... limit that succeeds in one database and fails in another on the same server? ... EXEC sp_configure 'default full-text language' ...
    (microsoft.public.sqlserver.programming)
  • Re: Checking for existence of a table that is already full-text indexe
    ... EXEC sp_fulltext_catalog 'PubInfo', 'drop' ... > Full-text indexing was manually set up to work on the development server. ... I need to write a SQL script to programmatically set up Full-text ...
    (microsoft.public.sqlserver.fulltext)