Very strange bug: MYSQL treats two characters the same.

[Sindre Aarsaether]

Hi. I bumped into a strange mysql-bug today. In short; It seems MYSQL is treating two DIFFERENT utf8-characters the same (in query).

mysql> SELECT * FROM test WHERE word = 'testchar_å';
+----+------------+
| id | word |
+----+------------+
| 1 | testchar_å |
+----+------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM test WHERE word = 'testchar_a';
+----+------------+
| id | word |
+----+------------+
| 1 | testchar_å |
+----+------------+
1 row in set (0.00 sec)

As you can see, although the actual output is correct, it treats the character 'a' and 'å' (norwegian aa) as if it were the same. All settings,databases,tables are correctly set to utf8, and i've tried both innoDB,MyIsam, and set the field to varchar,char,text. Same error still. This is getting very frustrating.

Any help would be greatly appreciated!