641443 - The encoding of the realname field is wrong when set up through checksetup.pl

Status: NEW

(Bugzilla :: Installation & Upgrading, defect)

Description

[Ozan Caglayan]

User-Agent:       Mozilla/5.0 (X11; Linux x86_64; rv:2.0b9) Gecko/20110129 Firefox/4.0b9
Build Identifier: 4.0

When you first set up a bugzilla installation through the checksetup.pl, the real name is wrongly injected into the bugs.profiles table.

Ex:

Real name: Ozan Çağlayan

mysql> select userid,realname from profiles where login_name LIKE "%ozan%";
+--------+----------------------+
| userid | realname             |
+--------+----------------------+
|      1 | Ozan Çağlayan      | <-- This is created within checksetup.pl
|      3 | Ozan Çağlayan        | <-- This is created through the Admin panel
+--------+----------------------+
2 rows in set (0.00 sec)



Reproducible: Always

Comment 1

[Max Kanat-Alexander]

Interesting! What's the encoding used in your terminal?

Comment 2

[Ozan Caglayan]

UTF-8

Comment 3

[Max Kanat-Alexander]

Okay. It's possible that we're not setting the utf8 flag properly on STDIN.

Comment 4

[Frédéric Buclin]

WFM using your real name with Bugzilla 4.1.1 and PostgreSQL 9.0.1.

Comment 5

[Frédéric Buclin]

(In reply to Frédéric Buclin from comment #4)
> WFM using your real name with Bugzilla 4.1.1 and PostgreSQL 9.0.1.

Also WFM with Bugzilla 4.0.2 + 4.3 and MySQL 5.5.10. But I remember having seen this problem in the past (but I forgot with which version of Bugzilla). Leaving the bug open for now.

Comment 6

[Frédéric Buclin]

I can reproduce using Mageia 3 + Bugzilla 4.5 + Oracle 10.0.2.