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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 14 Sep 2006 15:50 GMT

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?

Reply to this Message

Hilary Cotter - 14 Sep 2006 17:00 GMT

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.

Signature

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

> Hi,
>
[quoted text clipped - 7 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message

James Kaiser - 29 Sep 2006 00:59 GMT

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?

> 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
[quoted text clipped - 11 lines]
>>
>> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message

Hilary Cotter - 29 Sep 2006 03:13 GMT

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

Signature

>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 clipped - 14 lines]
>>>
>>> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message