MySQL Forums :: Full-Text Search :: fulltext search with utf8 characters (umlaut) with 5.1


Advanced 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 7505 david halter 09/21/2010 04:31PM
Re: fulltext search with utf8 characters (umlaut) with 5.1 2818 Rick James 09/23/2010 09:11AM
Re: fulltext search with utf8 characters (umlaut) with 5.1 2851 david halter 09/24/2010 08:13AM
Re: fulltext search with utf8 characters (umlaut) with 5.1 2609 Rick James 09/24/2010 09:56PM
Re: fulltext search with utf8 characters (umlaut) with 5.1 2995 david halter 09/26/2010 02:03PM
Re: fulltext search with utf8 characters (umlaut) with 5.1 2109 Rick James 09/26/2010 08:28PM
Re: fulltext search with utf8 characters (umlaut) with 5.1 3206 Carsten Imhof 11/13/2010 01:18AM


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.