modify a character set file: add & and - as word characters
Posted by: Sean Fang
Date: September 24, 2006 10:02AM

Hi,

I'm using fulltext search and need to make & and - word characters in the fulltext indexes.

I read the foolowing message from online reference manual at dev.mysql.com:

================================================
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 <ctype><map> 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.
================================================

But it looks quite remote to me since I'm very experienced with fulltext search yet.

I was able to find the character set files in mysql/characters/ folder. BUT, i don't know where to start adding them to <ctype><map> contents and later how to rebuild the fulltext indexes using the character set file?


Can anyone please help? I'm not sure what dev.mysql.com was thinking about by puting such a not step-by-step detail-level manual online to help beginners like me?

Thanks,

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.