Wednesday, March 7, 2012

Noisewords during insertation and during query

Hello, I wonder:

When I insert a text into a fulltexttable, the noisewords will be eliminated. Fine!

When I query, will the noiswords be eliminated automatically as well?

Thanks

Thomas

Thomas Boffo, (FRA) wrote:

When I insert a text into a fulltexttable, the noisewords will be eliminated. Fine!

? Where did you get that information from ? The noisewords will not be eliminated in the table, they will not be listed in the fulltext catalog, but they are still existing in the table.


Thomas Boffo, (FRA) wrote:

When I query, will the noiswords be eliminated automatically as well?

Depending on your setup language for wordbreaking the noise words will be eliminated according to the entries in the (language sensitive) noise word catalog.

Jens K. Suessmeyer

httpL://www.sqlserver2005.de

No comments:

Post a Comment