Groups | Blog | Home
all groups > sql server full text search > september 2006 >

sql server full text search : Full Text search for 'C#' and 'C++'


Hilary Cotter
9/14/2006 12:00:00 AM
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.nwsu.com/0974973602.html

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



[quoted text, click to view]

Sam
9/14/2006 7:50:45 AM
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?

James Kaiser
9/28/2006 6:59:56 PM
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?

[quoted text, click to view]

Hilary Cotter
9/28/2006 10:13:15 PM
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.nwsu.com/0974973602.html

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



[quoted text, click to view]

AddThis Social Bookmark Button