Hi, Sorry, I finally found I also have to add set-variable = ft_min_word_len=3 in my.cnf.
Regards, Jocelyn Fournier ----- Original Message ----- From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Sergei Golubchik" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:58 PM Subject: Re: Bug in fulltext search in latest mysql-4.0.2 source > Hi, > > I don't understand, I modified ulong ft_min_word_len=3; in > myisam/ft_static.c, and then recompiled MySQL using > BUILD/compile-pentium --without-innodb script, but show variables still > displays after restarting mysql : > > | ft_min_word_len | 4 > | > | ft_max_word_len | 254 > | > | ft_max_word_len_for_sort | 20 > > Any idea of what could be wrong ? > > Thanks and regards, > Jocelyn Fournier > > ----- Original Message ----- > From: "Sergei Golubchik" <[EMAIL PROTECTED]> > To: "Jocelyn Fournier" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, May 16, 2002 12:58 PM > Subject: Re: Bug in fulltext search in latest mysql-4.0.2 source > > > > Hi! > > > > On May 15, Jocelyn Fournier wrote: > > > A small question : > > > > > > I have : > > > > > > CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) > > > > > > in the field 'nom' . > > > How could I match BCI-11N for exemple ? (BCI* return nothing :( ) > > > > > > Thanks, > > > Jocelyn > > > > Actually, it's a question for [EMAIL PROTECTED], not for bugs@, > > but anyway - you need to decrease ft_min_word_len variable and > > rebuild your indexes (the proper way to do it is to issue > > REPAIR table_name USE_FRM > > but be sure to use the latest sources, as I've just fixed a crash in > > this code). > > > > Regards, > > Sergei > > > > -- > > MySQL Development Team > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > > <___/ > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php