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

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<hickseydr-sFbbPxZDHXw0n/[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

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