MySQL Fulltext search hyphen workaround using charsets
I have a server running FreeBSD with MySQL 4.0.17. This server is hosting a website in which I'm using a script utilizing MySQL's FULL-TEXT indexing. The problem, is that this website has numerous part numbers containing a hyphen and the FULL-TEXT search breaks words at the hyphen. I need it to treat hyphens as a alphanum character and recompilation is not an option. I was hoping I could modify a charset file as mentioned in the MySQL manual, however, in the /usr/local/share/mysql/charsets/ directory there are no XML files. There are .conf file which contain tables. I don't think this is what fulltext is using and not what the manual is refering to. Is this because the MySQL I'm running is so old?