Bug#597652: redmine: In some contexts accented characters don't display correctly
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:je...@edagames.com] > Sent: Wednesday, September 22, 2010 13:11 > To: "J.Tóth Gábor"; 597...@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. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
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. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#597652: redmine: In some contexts accented characters don't display correctly
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:j...@jnet.hu]
> Sent: Wednesday, September 22, 2010 11:49
> To: 'Jérémy Lal'; '597...@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:je...@edagames.com]
> > Sent: Wednesday, September 22, 2010 0:51
> > To: 597...@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
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
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:je...@edagames.com] > Sent: Wednesday, September 22, 2010 0:51 > To: 597...@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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#597652: redmine: In some contexts accented characters don't display correctly
On 21/09/2010 23:05, J.Tóth Gábor wrote: > Hi there, I tested the issue with Iceweasel and Epiphany on Debian (the box > redmine is running on), and IE8 and Opera (10.61) on a WinXP box. > > Let me know what else I can help with. Thank you for the precisions, i believe the bug is upstream, sometimes their language files are not properly encoded in UTF-8. Not sure we can rise this as an RC bug ; anyway redmine 1.0.2 will soon be available, and i'll take care this issue is fixed with that release. Regards, Jérémy. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#597652: redmine: In some contexts accented characters don't display correctly
On 21/09/2010 22:10, Gábor J.Tóth wrote: > Package: redmine > Version: 1.0.1-1 > Severity: normal > > When using Hungarian as the default language, in certain contexts some > accented > characters (notably "ő" and "ű", missing from the Latin-1 > character set), don't display correctly (replaced by a question mark), while > in > others they do. The attached screen shot shows an example for both. Hi, do you reproduce this issue in any browser ? if not, which ones ? More precisely, do you reproduce the issue on a debian box ? Regards, Jérémy. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
