I’ve been trying for the last couple days to use MySQL’s full-text indexing with accent-insensitivity with no success.
From what I know, when you’re using accent-insensitive strings it doesn’t matter what is the case of the accented characters. For example, café and CAFÉ (coffee, in portuguese) are considered the same.
Well, it just doesn’t work that way. I’m using the utf8 charset and the utf8_unicode_ci collation. I created a fulltext index on two columns and it will return different results when using different cases of the same accented character.
Does anybody have any clues? I’m about to create two lower-case columns specifically for the purpose of indexing. Although I really don’t like this solution, I think it’s the only way to make it work as supposed.