Hi Adam, Please see http://git.mantisbt.org/?p=mantisbt.git;a=commit;h=65f51280e646b3821ab6444689d8b0472ab23145
This was the last commit before 1.2.0rc1 was branched. Note that this change will only affect new databases that are created with versions of Mantis > 1.2.0rc1. Bug #9216 has a little further explanation of why the above mentioned commit was necessary. As you're using an existing database, you'll need to manually convert your database collation to either utf8_general_ci, utf8_unicode_ci or possibly utf8_swedish_ci. See http://dev.mysql.com/doc/refman/6.0/en/charset-unicode-sets.html for a full list of options available to you and why you'd want to use a collation other than Mantis' default of utf8_general_ci. Regards, David On Wed, 2009-07-01 at 12:24 +0200, Adam Zivner wrote: > 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 > > ------------------------------------------------------------------------------ > _______________________________________________ > mantisbt-help mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mantisbt-help > ------------------------------------------------------------------------------ _______________________________________________ mantisbt-help mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mantisbt-help
