Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Full-text search with small words Expand / Collapse
Author
Message
Posted Friday, May 10, 2013 3:31 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 12, 2014 9:30 AM
Points: 513, Visits: 1,129
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




If you need to work better, try working less...
Post #1451486
Posted Friday, May 10, 2013 3:42 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 6:52 AM
Points: 179, Visits: 821
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
Post #1451492
Posted Friday, May 10, 2013 3:49 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 12, 2014 9:30 AM
Points: 513, Visits: 1,129
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




If you need to work better, try working less...
Post #1451497
Posted Friday, May 10, 2013 10:01 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 12, 2014 9:30 AM
Points: 513, Visits: 1,129
Tried to "play" with the stoplist and stopwords but still 1 character words aren't indexed.
Please hellpppp!!!

Thx,
Pedro




If you need to work better, try working less...
Post #1451670
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse