RE: FN-FORUM: MySql Escaping -

date posted 17th October 2006 11:44

Dam.. I have access to neither... :( But thanks any way. I think the
only thing for me to do is replace the - with someother character and
then replace it back when it gets displayed..


-----Original Message-----
From: Tony Crockford [EMAIL REMOVED]
Sent: 17 October 2006 11:46
To: Charles E. Gatenby
Subject: Re: FN-FORUM: MySql Escaping -


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