Hi!
I´ve just added "full text search" to our SQL Server 2000 -system. But I don´t know what is wrong with it because it don´t find any records with "Contains" -value. Here is one example query:
SELECT ID, asset_name, folder_name FROM picturedatabase WHERE Contains(categories, 'woman OR car')
I´ve also tried simple
SELECT ID, asset_name, folder_name FROM picturedatabase WHERE Contains(categories, 'cat') but with no results. Only "0 pictures found". I know that there are words "woman" and "car" I have also option to search with picturename in the same search and it works great. In the end of the search is line "OR asset_name LIKE 'blaablaa%'"
That line gives results normally. Search is also very fast, it takes only 1,5 seconds to search from 160.000 rows.
But what is wrong with that "Contains" -search. "Categories" -fieldtype is nvarchar(1000).
I´ve just added "full text search" to our SQL Server 2000 -system. But I don´t know what is wrong with it because it don´t find any records with "Contains" -value. Here is one example query:
SELECT ID, asset_name, folder_name FROM picturedatabase WHERE Contains(categories, 'woman OR car')
I´ve also tried simple
SELECT ID, asset_name, folder_name FROM picturedatabase WHERE Contains(categories, 'cat') but with no results. Only "0 pictures found". I know that there are words "woman" and "car" I have also option to search with picturename in the same search and it works great. In the end of the search is line "OR asset_name LIKE 'blaablaa%'"
That line gives results normally. Search is also very fast, it takes only 1,5 seconds to search from 160.000 rows.
But what is wrong with that "Contains" -search. "Categories" -fieldtype is nvarchar(1000).