Hi, that's great and a little bit funny too as I encountered the problem on a CVS version from 2009/6/19, just four days before the fix was commited.
Anyway, thanks a lot for the fix and reply! On Wed, Jul 1, 2009 at 12:40 PM, David Hicks<[email protected]> wrote: > 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 > -- 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
