Re: unexpected behavior with certain words "i"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

single numbers are index if they are not in the noise word list.

--
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
"Thorsten Jakobsson" <ThorstenJakobsson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:B938159D-A15B-4414-B034-1714D2A4B63B@xxxxxxxxxxxxxxxx
This drives me crazy, I thought I had it figured out. I removed "b" from
the
noiseSVE.txt and removed, created and populated the fulltext table.
It works so, I thought it was working. But when I try to search for "1" or
"ett"
("ett" is one in swedish), it just doesn't work. I have tried to remove
everything in
noiseSVE.txt and just leave a single space, when that didn't work I tried
to
have just the word "XXXXXXXXXXX" in the noiseSVE.txt file. It doesn't
work.

This search returns nothing:
SELECT DISTINCT fwd_all,cn.CA_CATALOG_ID FROM CA_CATALOG_New_SEARCH cn
WHERE
(CONTAINS(FWD_ALL,'"ett"'))

this returns 488 rows:
SELECT DISTINCT fwd_all,cn.CA_CATALOG_ID FROM CA_CATALOG_New_SEARCH cn
WHERE
FWD_ALL like '% ett %'

this returns 840 rows:
SELECT DISTINCT fwd_all,cn.CA_CATALOG_ID FROM CA_CATALOG_New_SEARCH cn
WHERE
(CONTAINS(FWD_ALL,'"b"'))

Is there a special case for single numbers? Are single numbers not indexed
in fulltext search?
But for example "10" works alright.

this returns 295 rows
SELECT DISTINCT fwd_all,cn.CA_CATALOG_ID FROM CA_CATALOG_New_SEARCH cn
WHERE
(CONTAINS(FWD_ALL,'"10"'))

What is going on?

Thorsten


.