2012年3月21日星期三

Full text Problems

Hi all, my english is very bad, so i try to explain...

when i put the string

and Contains (PG.GenericTitleFullTxt,'"* Dias *" AND "* que *"AND "* Abalaram *" AND "* Mundo * "')

in my query, the results show up.... but is only i put the " * O * " in the search string and not shows ..something linke

and Contains (PG.GenericTitleFullTxt,'"* Dias *" AND "* que *"AND "* Abalaram *" AND "* O * " AND * Mundo * "')

All the conditions for the "and" exists....in my catalog i have the string

Dias que Abalaram O Mundo

many times..bu if i put the "O" in the search ...not shows nothing...

I droped the catalog, indexes..rebuild..etc...

Anyone can help me ?

Thanks..

First of all, you should leave the blank before and after the words, as the word breaker has already broken the words in the database to small pieces which can be recognized. if the words you are searching for are all single words you should also leave the * signs due to the same reasons mentioned above.

Jens K. Suessmeyer

http://www.sqlserver2005.de

没有评论:

发表评论