patriko2000
07-10-2002, 11:58 PM
Okay, here's the story:
You probably know about the MySQL search technique known as "FULL-TEXT," though it isn't very customizable. However, all I want to change is the minimum word length (aka "ft_min_word_len"). Everytime I try to change the system variable to equal 2, instead of 4, it reverts itself back to the default automatically. I used myisamchk.exe to accomplish this with this line in the console window:
myisamchk -O ft_min_word_len=2
Seems simple enough, right? Wrong. All it does is revert back to 4 (no matter what). I've tried reinstalling/initializing MySQL, alongside all the tables in the database I'm using FULL-TEXT search in. Does anyone know how to make this variable remain constant?
You probably know about the MySQL search technique known as "FULL-TEXT," though it isn't very customizable. However, all I want to change is the minimum word length (aka "ft_min_word_len"). Everytime I try to change the system variable to equal 2, instead of 4, it reverts itself back to the default automatically. I used myisamchk.exe to accomplish this with this line in the console window:
myisamchk -O ft_min_word_len=2
Seems simple enough, right? Wrong. All it does is revert back to 4 (no matter what). I've tried reinstalling/initializing MySQL, alongside all the tables in the database I'm using FULL-TEXT search in. Does anyone know how to make this variable remain constant?