You are reading a single comment by @mashton and its replies. Click here to read the full conversation.
  • This might be a way of getting it to work, but some index size testing would be needed:

    (from http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html)

    "If you want to change the set of characters that are considered word characters, you can do so in two ways. Suppose that you want to treat the hyphen character ('-') as a word character. Use either of these methods:

    • Modify the MySQL source: In myisam/ftdefs.h, see the true_word_char() and misc_word_char() macros. Add '-' to one of those macros and recompile MySQL.
    • Modify a character set file: This requires no recompilation. The true_word_char() macro uses a “character type” table to distinguish letters and numbers from other characters. . You can edit the contents in one of the character set XML files to specify that '-' is a “letter.” Then use the given character set for your FULLTEXT indexes.

            After making the modification, you must rebuild the indexes             for each table that contains any FULLTEXT             indexes."
      
About

Avatar for mashton @mashton started