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 |