Re: Won't ignore noise words, even after editing noise.enu -- HELP!
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Wed, 10 Jan 2007 21:47:49 -0500
The English stop words are in all noise word lists, even Chinese. eng is uk
English which corresponds to a lcid of 1036, US English has the noise word
list of noise.us and the lcid is 1033.
What do you get when you query select @@language and sp_configure 'default
full-text language'
The place to find the pertinent noise words for SQL Server 2005 is
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\FTData where x is your
instance number
For sql 2000 its in
c:\Program Files\Microsoft SQL Server\mssql\ftdata\sqlserver\config
or
c:\Program Files\Microsoft SQL
Server\mssql$InstanceName\ftdata\sqlserver$InstanceName\config
--
Hilary Cotter
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
<markdavies2003@xxxxxxx> wrote in message
news:1168471792.985421.150240@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm trying to get SQL Server to ignore the noise words for the
Full-Text indexed content in a given column. I've edited the noise.eng
and noise.enu files in the c:\winnt\system32 directory so they only
have one word: qxqxqxq. So any other words will not be ignore and will
get get indexed, right?
But it's not working. After dropping the existing FT index, editing the
noise file, re-starting the SQL Server Full-Text and SQL Server
services, and then creating a new FT index, it still ignores what it
thinks are noise words. For example, I search for "as far as":
CONTAINS (colName, '"as far as"'))
but it finds all rows with "far", whether or not they have "as far as"
-- it just ignores "as", since it still considers this a noise word.
I've also tried changing the default FT Index langauge to something
besides English, like Chinese -- thinking that "as" probably isn't a
Chinese noise word (Server / Properties / Advanced / Default Full-Text
Language; changing 1033 to 1028). But same problem, even after starting
and re-starting services, etc etc.
I've spent four hours on this now, and no luck. Any suggestions? Thanks
in advance.
Mark D.
.
- References:
- Won't ignore noise words, even after editing noise.enu -- HELP!
- From: markdavies2003
- Won't ignore noise words, even after editing noise.enu -- HELP!
- Prev by Date: Re: Can't change filegroup
- Next by Date: Re: Fulltext Search or Like Search
- Previous by thread: Re: Won't ignore noise words, even after editing noise.enu -- HELP!
- Next by thread: Re: Fulltext Search or Like Search
- Index(es):
Relevant Pages
|
