Real name with diacritic (accented characters), wrong database schema?

Hi, I have problem with storing user names with accented characters.

Problem is in the function user_get_id_by_name() in the query

SELECT * FROM mantis_user_table WHERE username='Adam Živnéř'

Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='

Which makes sense.

Solution is simple: change charset of columns "username" and
"realname" of "mantis_user_table" to UTF-8.

The question is, why is UTF-8 not the default schema encoding? Not all
users can detect or fix the problem ...

I'm running on clean installation of recent CVS version (pre rc1) on
MySQL 5.1.30, but I encountered the same problem on 5.0.

--
S pozdravem Adam Živnéř | ICQ: 354-750-968 | Mobil: 775 610 300

------------------------------------------------------------------------------