MySQL Forums
Forum List  »  Full-Text Search

FT search problem with utf8 characters
Posted by: Jan Bronee
Date: March 26, 2008 04:21PM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
FT search problem with utf8 characters
3989
March 26, 2008 04:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.