Hi, Sergei.

In myisam/ftdefs.h I changed:

#define MIN_WORK_LEN 4

to:

#define MIN_WORD_LEN 2

and I commented out the line:

#define COMPILE_STOPWORDS_IN
(this should leave out stopwords right?)

There were no changes to ftstatic.c

recompile, reinstall, restart mysql.

To test I dropped and recreated the fulltext index on the existing table. Fulltext search didn't find any 2 or 3 character words.

I also created a new table (from the articles example in the mysql manual) and that didn't see any 2 or 3 character words either.

thanks

On Wednesday, November 20, 2002, at 09:18 AM, Sergei Golubchik wrote:

Hi!

On Nov 18, Kevin Lewandowski wrote:
I'm using mysql fulltext indexes and want them to see words of 2 or
more characters, and no stopwords. I've edited the appropriate files
(ftdefs.h, ft_static.c), then recompile, install, restart mysql,
rebuild indexes, and there is no change. It still uses a minimum of 4
characters). I'm using mysql 3.23.52-max. Am I missing something? Can
anyone help?
What changes, exactly did you make in ftdefs.h and ft_static.c ?
How did you test, whether 2-char words are indexed or not ?

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



________________
Kevin Lewandowski
Discogs - http://www.discogs.com


---------------------------------------------------------------------
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

Reply via email to