MySQL Forums
Forum List  »  Full-Text Search

fulltext search with utf8 characters (umlaut) with 5.1
Posted by: david halter
Date: September 21, 2010 04:31PM

The following FTS example seems not to work:
-----------------------------
CREATE TABLE IF NOT EXISTS `fullTextTable` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `nameFull` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

insert into `fullTextTable` (name) values('bärtsch'),('börtsch'),('böll'),('büll');

select * from `fullTextTable` where match(name) against('+bärtsch' in boolean mode);

drop table `fullTextTable`;
-----------------------------
Returns:
+----+----------+
| id | name |
+----+----------+
| 1 | bärtsch |
| 2 | börtsch |
| 3 | böll |
+----+----------+

Could anyone tell me, why FTS returns wrong words? This exists just in combination with umlauts (only tested the german umlauts).

It might also be a bug.

Cheers!
David

Options: ReplyQuote


Subject
Views
Written By
Posted
fulltext search with utf8 characters (umlaut) with 5.1
7690
September 21, 2010 04:31PM


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.