331816 - twice utf8 encoding in MySql database

Status: RESOLVED DUPLICATE of bug 331583

(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

[Teemu Mannermaa (:wicked)]

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