July 24, 2007 at 10:09 am
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..
July 24, 2007 at 2:11 pm
It somehow can be related to the noise words.
If you read the Books Online article Noise Words
http://msdn2.microsoft.com/en-us/library/ms142551.aspx
it says that these words "are left out of the full-text index"
I checked the English version of the file noiseENG.txt and it contains all letters. Your condition says AND so the word O have to be in the index and it is not. that is why you are not getting results. If it is important to you to have the letter O you can edit the file and re-populate the catalog, but then the catalog may be too big.
Regards,Yelena Varsha
July 24, 2007 at 2:24 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply