Red Hat Bugzilla – Bug 438197
incorrect encoding on show_bug page
Last modified: 2013-07-31 19:12:42 EDT
Description of problem: names on show_bug page appears with incorrect characters see e.g. Reporter field on https://bz-web2-test.devel.redhat.com/show_bug.cgi?id=225570
Tony do you mind looking at this?
Dave, Both client side and server side sql settings look fine and I can use sql client to get utf8 characters without any problem. So it shouldn't be a problem of sql server settings. I found that bugzilla generated html page on bz-web2-test.devel.redhat.com didn't include the following <head> information <meta http-equiv="content-type" content="text/html; charset=UTF-8">. I guess it causes the utf-8 characters display problem. Tony
I have tried added <meta http-equiv="content-type" content="text/html; charset=UTF-8"> to the headers without success. I also doubled checked the MySQL configuration being used by bz-web2 and it is correct. { mysql_enable_utf8 => 1 } $self->do("SET NAMES utf8"); I even added which is part of rh_bugzilla_2_18 $self->do("SET CHARACTER SET utf8"); Nothing made the characters appear different. If I select the data directly from MySQL it looks correct like Tony mentioned: mysql> SET NAMES utf8; Query OK, 0 rows affected (0.00 sec) mysql> select bug_id, profiles.login_name, profiles.realname from longdescs, profiles where longdescs.who = profiles.userid and longdescs.bug_id = 225570; +--------+---------------------+----------------+ | bug_id | login_name | realname | +--------+---------------------+----------------+ | 225570 | rbiba@redhat.com | Radek Bíba | | 225570 | jlieskov@redhat.com | Jan Lieskovsky | | 225570 | jhutar@redhat.com | Jan Hutař | | 225570 | dkovalsk@redhat.com | David Kovalsky | | 225570 | rbiba@redhat.com | Radek Bíba | | 225570 | rbiba@redhat.com | Radek Bíba | +--------+---------------------+----------------+ Will need to investigate further and may talk to upstream.
Dave, It seems that the bugzilla code on bz-web2-test has some problems on utf8 support. I have tried to create a few new users whose real names include non-english characters and they couldn't be displayed properly. But I tested these users names on upstream code and the code checked out from our cvs repository, and there were NO problems on utf8 support. So I guess utf8 support problem is specific to the bugzilla code we are using on bz-web2-test. Tony
I found out what is causing this. The perl-DBD-MySQL that we ship with EL5 is older than the one we ship with EL4-stacks and needs to be updated. Once I updated to the newer perl-DBD-mysql on bz-web2-test the utf8 chars now look correct. I have added a ticket to eng-sysadmin@redhat.com to add this newer DBD-mysql to eso/el5 yum repo. http://brewweb.devel.redhat.com/brew/taskinfo?taskID=1234287 Dave