SELECT statement equals different characters

[Thorsten Friedrich]

Hi, i hope this is the right place to add my topic.

I have a very strange behavior in my query. But before posting a bug, let´s see if some knows about it and/or can help me to fix the problem.

First of all my configuration:

OS: Linux - Suse 11.2
MySQL: MySQL 5.1.36

Description/replication of the problem:

1. create a table using utf-8 as charset and ut8_unicode_ci as collation
CREATE TABLE `ctest` (
`keyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

2. insert a keyword with an 'non-ascii' value to the table
INSERT INTO ctest (`keyword`) VALUES ('münchen');
(you see the german umlaut ü for munich)

3. do a select on the table
SELECT * FROM ctest WHERE `keyword`='mûnchen';
NOTICE: i am selecting all keywords having û [normally a french character] instead of ü (german umlaut)

The database response with the line inserted in point 2.

I am a little bit confused. Doing a html-entity representation of these 2 characters, the following comes up:
ü = %C3%BC
û = %C3%BB

Thanks in advance

Thorsten