Full-text search and extended characters

[Josh Santangelo]

I'm working on an application that uses the MySQL full-text search to search
for words in pre-existing content. This content can and does contain HTML
entities like "ö".

At least in my setup, if I place words like "mögliche" in an AGAINST()
clause, incorrect results are returned. For example:

SELECT title, datetime,  MATCH(title, strippedtext) AGAINST('mögliche')
AS `m&ouml_3B_gliche` FROM content ORDER BY MATCH(title, strippedtext)
AGAINST('mögliche') DESC LIMIT 2;
+--------+---------------------+------------------+
| title  | datetime            | m&ouml_3B_gliche |
+--------+---------------------+------------------+
| 9-5    | 2002-10-04 08:08:31 |  5.8614664130118 |
| Trauer | 2001-11-27 04:03:42 |  2.2698967450068 |
+--------+---------------------+------------------+

The strippedtext field for the first row contains "mögliche" and is
properly returned as the first result. The second row does not contain
"mögliche" at all, and seems like it should have a relevancy of zero.

Is there a solution for this, or do I need to be searching only with the
actual "ö" character instead?

Thanks,
-josh


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php