Full Text Search Question again
Posted on 2004-08-15
I need your guys help quickly
Our FTS query, had decided to be uncooperative and not work on our live SQL box:
SELECT HotelSearchLookup.Hotel_Code, A.Rank
FROM HotelSearchLookup AS HotelSearchLookup
INNER JOIN CONTAINSTABLE(HotelSearchLookup, *, 'アグラ空港') AS A ON HotelSearchLookup.ID = A.[KEY]
GROUP BY HotelSearchLookup.Hotel_Code, A.Rank
ORDER BY A.Rank Desc
This works fine on the development box, in any language we see fit to throw at it. I have looked and looked and cant find any differences between the two servers. I have even copied the noise word files between the two. It still returns the following on the live box only:
"Execution of a full-text operation failed. A clause of the query contained only ignored words. "
Where should i be looking for differences between the two machines, i have tried many things:
All giving me the same results on each box.
English is ok, as is any other roman char set, but Japanese and chinese, all return the above error. Where should i be looking experts? I have also emptied the noise files for those langauges and rebuilt the catalog on serveral occasions.