Discussion:
Misinterpretation of the dash "-" character ?
(too old to reply)
f***@gmail.com
2006-06-29 14:45:24 UTC
Permalink
Hello,

We are using the Microsoft indexing service in our web applications
(.NET) for some time now. Recently, I found that when i enter a keyword
including a dash character "-" along with at least one number, the
results I'm getting are just plain wrong. For example, in one of our
application, if I enter "ce-2006-001" and then lauch the query, I'm
getting results but the string "ce-2006-001" is nowhere to be found in
the returned files. I know there is nothing wrong in my code because
I'm getting the same behavior when I use the Query tool included in the
Microsoft indexation service.

Does the indexing service interprets the dash character in a particular
manner or am i simply missing something?

Indexing service is running on a Windows 2003 Server.

Sorry for my clumsy english

Thanks for your help
François
Deneb
2006-07-03 14:16:46 UTC
Permalink
Ok, I still haven't found a solution but I have some more infos on this
problem... maybe it will help if some of you run into it one day.

It seems that the dash "-" character is interpreted correctly in the
following scenarios :

1) The dash is contained in an expression that contains letters only
(ex : Saint-Louis)
2) The dash is contained in an expression that contains numbers only
(ex : 555-555-5555)

However, whenever you mix numbers with letters, it stops working. In
fact, you will find more results than you normally should.

I'll take my case for example :

In one of our solutions, when I search for the string "05-80-00-0-005",
i get the right number of results, each of them containing the string
"05-80-00-0-005". Now, when I search for the string
"helloworld!!!-05-80-00-0-005" or "05-80-00-blablabla-0-005", I still
get results... I even get more results than when I searched for
"05-80-00-0-005"... and obviously those results dont contains the
expression "helloworld!!!-05-80-00-0-005"

Here is how I query the indexing service in my .net search engine
component :
Select filename,contents from scope() where CONTAINS(contents,'" &
keywordsSql & "')

At the moment I have no idea where the problem is... I'll let you know
if I learn something more on the subject.

Bye
François

Loading...