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

[J.Tóth Gábor]

Hi, Jérémy,

MySQL 5.1 defaults to Latin-1 and the config files in Squeeze don't
apparently override it.  So, yes, MySQL is not UTF-8 in Squeeze.

So as a minimum, the install script should make sure that the default
character set of the redmine database is UTF-8.  And, to me at least, this
sounds much like an RC bug.

In addition, it might also make sense to set the collation sequence of the
redmine database/tables to match the language redmine is using.  Of course,
this could become quite tricky when reconfiguring redmine changing the
language...  But as the default collation sequence appears to be more or
less decent, this would surely not be RC.

  --jtg

> -----Original Message-----
> From: Jérémy Lal [mailto:jerry at edagames.com] 
> Sent: Wednesday, September 22, 2010 13:11
> To: "J.Tóth Gábor"; 597652 at bugs.debian.org
> Subject: Re: Bug#597652: redmine: In some contexts accented 
> characters don't display correctly
> 
> On 22/09/2010 12:56, J.Tóth Gábor wrote:
> > 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:
> 
> MySQL is not UTF-8 by default in debian?
> That's a big surprise to me.
> Are you on debian/squeeze ?
> 
> Jérémy.