331583 - twice utf8 encoding in MySql database

Status: RESOLVED DUPLICATE of bug 304550

(Bugzilla :: Database, defect)

Description

[lixan]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.8) Gecko/20051107 Firefox/1.5
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.8) Gecko/20051107 Firefox/1.5

Data sending from bugzilla to MySql encoded to utf8 from utf8.

When Bugzilla establish connection to MySql, it open connection with character set 'latin1', even if bugzilla work in 'utf8' mode.

I am correct this bug by correcting Bugzilla\DB\mysql.pm on line 70

old:
    $self->{private_bz_tables_locked} = "";
    bless ($self, $class);
new:
    $self->{private_bz_tables_locked} = "";
    $self->do("SET NAMES utf8") if Param('utf8');
    bless ($self, $class);

Reproducible: Always

Steps to Reproduce:




Windows 2003 Server with SP1.
Bugzilla 2.22rc1 on IIS 6.0
MySQL 5.0.18 
ActivePerl 5.8.7 Build 518
DBI 1.49 
DBD::mysql 3.0002

Comment 1

[Marc Schumann [:Wurblzap]]

I'm seeing twice-encoded data, too.

This might get fixed by bug 328013 or bug 304550, perhaps...

Comment 2

[Max Kanat-Alexander]

*** This bug has been marked as a duplicate of 304550 ***

Comment 3

[Teemu Mannermaa (:wicked)]

*** Bug 331816 has been marked as a duplicate of this bug. ***