Bug 438197 - incorrect encoding on show_bug page
Summary: incorrect encoding on show_bug page
Keywords:
Status: CLOSED NEXTRELEASE
Alias: None
Product: Bugzilla
Classification: Community
Component: User Interface
Version: 3.2
Hardware: All
OS: Linux
low
low
Target Milestone: ---
Assignee: Tony Fu
QA Contact:
URL:
Whiteboard:
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:
Clone Of:
Environment:
Last Closed: 2008-03-31 17:41:03 UTC
Embargoed:


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
https://bz-web2-test.devel.redhat.com/show_bug.cgi?id=225570

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

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
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    | Radek Bíba    | 
| 225570 | jlieskov | Jan Lieskovsky | 
| 225570 | jhutar   | Jan Hutař     | 
| 225570 | dkovalsk | David Kovalsky | 
| 225570 | rbiba    | Radek Bíba    | 
| 225570 | rbiba    | Radek Bíba    | 
+--------+---------------------+----------------+

Will need to investigate further and may talk to upstream.



Comment 4 Tony Fu 2008-03-25 07:02:48 UTC
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

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 to add this newer DBD-mysql to
eso/el5 yum repo.

http://brewweb.devel.redhat.com/brew/taskinfo?taskID=1234287

Dave


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