Gentoo Archives: gentoo-user

From: Bruno Lustosa <bruno.lists@×××××.com>
To: gentoo-user@l.g.o
Subject: [gentoo-user] Unicode error in bugzilla
Date: Tue, 19 Jul 2005 14:32:57
Message-Id: b9e0c3fe050719072756694a3b@mail.gmail.com
1 Hello, I emerged bugzilla yesterday, using postgresql as database.
2 However, I can't enter any accented characters anywhere (bugs
3 description, name, subject, etc). It will give me the following error:
4
5 Software error:
6
7 DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding
8 "UNICODE": 0xe7
9 [for Statement "INSERT INTO bugs
10 (version,rep_platform,bug_severity,priority,op_sys,assigned_to,bug_status,bug_file_loc,short_desc,target_milestone,everconfirmed,product_id,component_id,
11 reporter, delta_ts, estimated_time, remaining_time, deadline) VALUES
12 ('1','PC','normal','P2','Linux','1','NEW','','çççç','---','1','2','2',1,
13 '2005-07-19 10:56:40.663303-03', 0, 0, NULL)"] at Bugzilla/DB.pm line
14 81
15 Bugzilla::DB::SendSQL('INSERT INTO bugs
16 (version,rep_platform,bug_severity,priority,...') called at
17 /var/www/localhost/htdocs/bugzilla/post_bug.cgi line 386
18
19 >From what I guess, it's trying to send the raw iso-8859-1 "c-cedilla"
20 directly over a unicode connection. In PHP, I'd solve this using a
21 simple pg_set_client_encoding() call, however I don't know the right
22 way to do it under Perl.
23 Can someone shed some light? Perhaps change database encoding to
24 latin1? My system is all unicode (utf-8) here.
25
26 --
27 Bruno Lustosa, aka Lofofora | Email: bruno@×××××××.net
28 Network Administrator/Web Programmer | ICQ: 1406477
29 Rio de Janeiro - Brazil |
30
31 --
32 gentoo-user@g.o mailing list