How to force FTS on fractions?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis4j - 29 Oct 2006 20:36 GMT

When I made the jump to SQL 2005 from SQL 2000, the following query stopped
working. ie no result set unless I remove the fraction 1/4.
(Removing the fraction 1/4 works, but then returns many many rows)

SELECT * FROM MAKT
WHERE CONTAINS(MAKTX,'"valve" AND "SS" AND "needle" AND "1/4"')

With my old database on SQL2000, the same query returns:
ID    MATNR    MAKTX
651295    02030710    Valve, needle, 1/4", body material ss
776519    02030890    Valve, needle, 1/4", body material ss
597565    02030900    Valve, needle, 1/4", body material ss
776516    02030860    Valve, needle, 1/4", body material ss
605637    02030990    Valve, needle, 1/4", body material ss
***

The SQL 2000 database was copied to a new WIN2003 x64 server with SQL 2005
pro x64. Other than OS and SQL version, the databases are identical. Both
databases have FTS on the table in question. SQL 2005 just won't return a
result set on fractions. Is there a switch or registry hack? Can I go back to
SQL2000 FTS engine?

Reply to this Message

Hilary Cotter - 30 Oct 2006 16:08 GMT

This works for me, what language are you querying and indexing in?

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

> When I made the jump to SQL 2005 from SQL 2000, the following query
> stopped
[quoted text clipped - 19 lines]
> to
> SQL2000 FTS engine?

Reply to this Message