Bug 438197

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

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

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

Dave