Full Text search for 'C#' and 'C++'

Full Text search for 'C#' and 'C++'

Post by Sam » Fri, 15 Sep 2006 23:50:45


Hi,

I am using SQLServer 2000. When i searched for 'C#' or 'C++'
Ex:
CONTAINS(Table.*, '"C#"')

getting results that does not have 'C#' or 'C++'.

Any help?

*** Sent via Developersdex http://www.yqcomputer.com/ ***
 
 
 

Full Text search for 'C#' and 'C++'

Post by Hilary Cot » Sat, 16 Sep 2006 01:00:53

this should work. If you search on C# it should match with C#, if you search
on c# you will get hits to c, c!, c#, c+. Are you running Windows 2000? I
believe this problem exists on Windows 2000.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/

 
 
 

Full Text search for 'C#' and 'C++'

Post by James Kais » Sat, 30 Sep 2006 08:59:56

I have a similar problem. If I search on C# it matches any document
containing C#. I get nothing returned if I search on c#. Any ideas?
 
 
 

Full Text search for 'C#' and 'C++'

Post by Hilary Cot » Sat, 30 Sep 2006 11:13:15

remove c from your noise word list, rebuilt your catalog, now searches on c#
will match with c#, c+, and c.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/