I have found in the docs where it describes how to add characters to the list of word characters used during fulltext searches. My table is encoded UTF8 and from what I can see, there isn't a character set file like latin1.xml. It's my understanding that I have to modify the source. Is that true?
If so, it is very vague in the manual how to modify. It only says what file to modify. My server came with a preconfigured binary version of mySQL so I'm not really clear how to grab the source, modify it, build it and then install it. I'm sure I can figure all of this out, but I'm wondering if it would just be easier to change the collation to latin1 for this particular table using the better documented steps I've found. Are there any pitfalls I should lookout for with having one table encoded differently?