[DRE-maint] Bug#597652: redmine: In some contexts accented characters don't display correctly

[J.Tóth Gábor]

Hi Jérémy,

I have now confirmed that the problem is related to the database encoding.
Here's what I did:

I changed the default character encoding of MySQL to UTF-8 (from the Debian
default of Latin-1) by adding the following lines to the mysql
configuration:

[mysqld]
collation_server=utf8_unicode_ci
character_set_server=utf8

After that, I deleted the redmine database ("DROP DATABASE
redmine_default"), and recreated it by "dpkg-reconfigure redmine".

After that, all characters are displayed correctly.

I'd guess setting the character encoding at server level is an overkill and
the proper encoding could be set at the database level by the dpkg
configuration script but that's just a guess.

This closes the issue for me but I guess the bug is still there.  Let me
know if I can be of further assistance in fixing it.

  --jtg

> -----Original Message-----
> From: J.Tóth Gábor [mailto:jtg at jnet.hu] 
> Sent: Wednesday, September 22, 2010 11:49
> To: 'Jérémy Lal'; '597652 at bugs.debian.org'
> Subject: RE: Bug#597652: redmine: In some contexts accented 
> characters don't display correctly
> 
> Hi Jérémy, 
> 
> I usually use Opera on WinXP but I occasionally cross-check 
> things on Iceweasel or Epiphany on Debian.
>  
> I tried setting the Encoding to UTF-8 (from automatic) but it 
> did not help.
> 
> I also tried creating a task with one of these "problem 
> characters" in its title and descriptor and it showed the 
> same problem.
> 
> BTW: I think not remaining the role names may be The Right 
> Thing, as these names could be customized anyway.
> 
>   --jtg
> 
> > -----Original Message-----
> > From: Jérémy Lal [mailto:jerry at edagames.com]
> > Sent: Wednesday, September 22, 2010 0:51
> > To: 597652 at bugs.debian.org
> > Cc: "J.Tóth Gábor"
> > Subject: Re: Bug#597652: redmine: In some contexts accented 
> characters 
> > don't display correctly
> > 
> > Which browser do you use when you change the role name ?
> > Could you check you are viewing the page in UTF-8 ?
> > I tested "Magyar" language on my local install, and noticed :
> > 1) roles stayed in the default install language (another bug...)
> > 2) if i renamed a role to "Vezető" the display was ok.
> > 
> > Jérémy.
> > 
> > On 22/09/2010 00:28, J.Tóth Gábor wrote:
> > > Hi, Jérémy,
> > > 
> > > I don't think this has much to do with the language files.  
> > > I looked into it and it looks OK.  In addition, I tried 
> to edit one 
> > > of the effected strings (role names), and it doesn't work: if I 
> > > rename the role name "Vezet?" to "Vezető", if changes 
> back to "Vezet?".
> > > If I rename it to "Vezetö" (all characters present in 
> Latin-1), it 
> > > succeeds.
> > > 
> > > On a further move, I looked into the mysql table that 
> seems to hold 
> > > this information, and the information in there is 
> incorrect already:
> > > 
> > > mysql> select name from roles;
> > > +------------+
> > > | name       |
> > > +------------+
> > > | Non member |
> > > | Anonymous  |
> > > | Vezet?     |
> > > | Fejleszt?  |
> > > | Bejelent?  |
> > > +------------+
> > > 5 rows in set (0.00 sec)
> > > 
> > > I'm rather novice in mysql tuning so I haven't got much 
> further then 
> > > this (yet).
> > > 
> > >   --jtg