Re: FN-FORUM: MySql Escaping -

date posted 17th October 2006 11:20

Charles E.Gatenby wrote:
> Just Tried it... And it doesn't work... :( But thanks for the
> suggestion..

you need to rebuild mysqld and comment out:

#define HYPHEN_IS_DELIM

or:

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.

from:
http://bugs.mysql.com/bug.php?id=2095
MySQL Bugs: #2095: full-text search for words containing hyphens won't work

hth