FT search problem with utf8 characters

[Jan Bronee]

Hi,

I have a record with this content:

-start-
5 kraft FT ok
5 kræft FT fail !! (observe the danish letter)
6 kræfte FT fail !!
7 kræfter FT ok !?
-end-

FT boolean search will find this record when searching for "kraft" but NOT "kræft" or "kræfte" (It WILL find using "kræfter")

Any ideas folks?

cheers
Jan


Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23 to server version: 5.0.27-community

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW VARIABLES LIKE 'ft%'
-> ;
+--------------------------+----------------+
| Variable_name | Value |
+--------------------------+----------------+
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
+--------------------------+----------------+
5 rows in set (0.00 sec)