Re: Problem with words like 'S&S' or 'W&W'
Posted by:
Neo G.
Date: February 23, 2009 09:15AM
Hi Tom,
The default configuration for FULLTEXT search only searches words that are 4 characters and more and there are also stop words. In order to bypass this, you will need to edit the mysql configuration file and add this under the [mysqld] section:
[mysqld]
ft_min_word_len=1
ft_stopword_file=''
Afterwards, make sure you do repair table TABLENAME quick to recreate the fulltext indexes to include shorter words.
Good luck.
Subject
Views
Written By
Posted
4565
January 08, 2009 02:29AM
Re: Problem with words like 'S&S' or 'W&W'
2937
February 23, 2009 09:15AM
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.