Bug 438197 - incorrect encoding on show_bug page
Summary: incorrect encoding on show_bug page
Alias: None
Product: Bugzilla
Classification: Community
Component: User Interface   
(Show other bugs)
Version: 3.2
Hardware: All
OS: Linux
low vote
Target Milestone: ---
Assignee: Tony Fu
QA Contact:
Depends On:
Blocks: RHBZ30UpgradeTracker
TreeView+ depends on / blocked
Reported: 2008-03-19 17:21 UTC by Michal Babej
Modified: 2013-07-31 23:12 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2008-03-31 17:41:03 UTC
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

Description Michal Babej 2008-03-19 17:21:17 UTC
Description of problem:

names on show_bug page appears with incorrect characters

see e.g. Reporter field on

Comment 1 David Lawrence 2008-03-19 17:32:06 UTC
Tony do you mind looking at this?

Comment 2 Tony Fu 2008-03-20 06:09:52 UTC

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.


Comment 3 David Lawrence 2008-03-20 16:58:45 UTC
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

{ 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.

Comment 4 Tony Fu 2008-03-25 07:02:48 UTC

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.


Comment 5 David Lawrence 2008-03-28 21:18:50 UTC
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.



Note You need to log in before you can comment on or make changes to this bug.