Unable to search for numeric partnumbers.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jainamber@gmail.com - 28 Sep 2005 23:10 GMT

Hi,
I have enabled full text search on the products table. It works as
expected most of the times but does not return any thing for keyword
like IL-8. Please try searching for IL and IL-8 on this
page(http://4.19.91.45/bs/searchresult.asp). The noise.eng file does
not have any numbers in it. Basically, it will return IL-20 for IL-2
but not IL-2.

I'll appreciate any help you can provide with this.

Amber

Reply to this Message

John Kane - 29 Sep 2005 02:11 GMT

Amber,
Could you post the full output of -- SELECT @@version -- from the server
where you are experiencing this problem? This it typically an issue with the
OS-supplied wordbreaker and the @@version will have the details.
Additionally, noise.eng is for UK English, while noise.enu is for US English
and be sure to modify the correct noise.* file under
\FTDATA\SQLServer\Config where you have SQL server installed.

Also, what is the sp_configure 'default full-text language' run_value for
this server? Note, after you've modified the correct noise word file, you
must run a Full Population and then re-test your SQL FTS query. Finally, are
you using CONTAINS or FREETEXT to query for these values?

Thanks,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> Hi,
> I have enabled full text search on the products table. It works as
[quoted text clipped - 7 lines]
>
> Amber

Reply to this Message

jainamber@gmail.com - 29 Sep 2005 17:34 GMT

Thanks John for your reply.
It seems I was editing the wrong noise file. After removing the numbers
from the nosie.enu file the search fuinctionality is working as
expected. Thanks for the help.

Amber

Reply to this Message