May 8, 2008 at 1:41 pm
Hi everyone
I'm programming a software that saves richtext formated Text into a mssql 2000 database. The rtf text is saved in a image (blob) field of my databasetable.
The software should be able to search in this text. So, because it is an image datatype, it need to be fulltextindexed.
I have done this and tried to search with
select * from entries where contains(text, '"*test*"')
It works, but the problem is that if i search for *taho* eg., it will find every entrie that is written with "tahoma" because of the indexed rtf formatingcode.
Is there a chance to avoid this?
May 30, 2008 at 3:40 am
What exactly are you searching for?
Using wildcards the way you've shown in your post will return results containing words beginning with "taho", which means your results were expected.
Also note that suffix searches (e.g. *text) are not supported, which means that the first wildcard in *text* is ignored by the search engine.
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply