Hello! I'm building a database that will have tables containing UTF-8-encoded text, and I want to use full-text indexing and searching for these fields.
The aim would be that I should be able to index the UTF-8 text, and then search it accent-insensitively - that is, a search query for "cliche" should find texts containing "cliche" and "cliché", as well. The problem is, that as far as I know, MySQL doesn't support the full-text indexing of UTF-8 (or any other multibyte encoding) text. Can you help me with this problem? It doesn't need to be MySQL-specific, as this is a totally general problem, affecting most database systems :| One possible solution would be to store every text twice - one version with accents, and one without them, indexing and searching the latter. But this would be an ugly redundancy, making data handling and manipulating more difficult. Is there a better solution? Regards, Peter http://prodigycenter.com/cv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
