Different FULLTEXT minimum word length for different databases - Possible?

andrewm

Word is that vBulletin 3 is finally going to support fulltext search by default in the next version, which should be coming out pretty soon.

My forum currently runs 2.3.X just like this forum. When I upgrade to 3.X I pretty have to use the fulltext search because there are a few million posts and the built-in VB index is really slow.

The problem is that I use fulltext search on another part of my site. This part searches over a small amount of text and it is necessary that the minimum word length is set to one character and there is no stopword list. I couldn't do this for the forum with a few million posts.

So, my question is:

Is it possible to have different fulltext settings for different databases?

andrewm

I think I am up you know what creek without a paddle.

Roger_Ramjet

You can change both the min word length and the stop word list. fine tuning full tetx search

andrewm

Originally posted by Roger Ramjet
You can change both the min word length and the stop word list. fine tuning full tetx search

Yes, but my question is, can diffferent databases on the same mysql server have different settings.

Roger_Ramjet

My reading of the manual is that the you cannot: the server systen variables that control this are not in the dynamic vars list .