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

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