May 10, 2013 at 3:31 am
Hi,
I'm implementing a full-text search in SQL Server but I have a doubt when searching for small words...
I use the CONTAINSTABLE(table, *, '"word1*" AND "word2*") for the all words search and CONTAINSTABLE(table, *, '"phrase") for exact search...
It works as expected, but when I search for "Windows 8" the all words search returns nothing cause the "8" is "dumped" and probably converted to NULL... The exact search returns all records with "Windows"..
Is there a way to solve this? "Tell" the full-text to index all words despite their size?
Thanks,
Pedro
May 10, 2013 at 3:42 am
Try the NEAR expression. That may solve the issue if you search for the word windows near 8. I assume(ok, shoot me down now) it works with numbers
BOL - CONTAINS(column_name, 'NEAR((John, Smith), 2)')
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 10, 2013 at 3:49 am
Don't know if its a configuration for the FULL-TEXT but the words with just 1 char are not indexed, they don't show up on the sys.dm_fts_index_keyords...
The NEAR solution doesn't work cause the "8" isn't on the words' catalog.
Thanks,
Pedro
May 10, 2013 at 10:01 am
Tried to "play" with the stoplist and stopwords but still 1 character words aren't indexed.
Please hellpppp!!!
Thx,
Pedro
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply