Hello, I emerged bugzilla yesterday, using postgresql as database. However, I can't enter any accented characters anywhere (bugs description, name, subject, etc). It will give me the following error:
Software error: DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding "UNICODE": 0xe7 [for Statement "INSERT INTO bugs (version,rep_platform,bug_severity,priority,op_sys,assigned_to,bug_status,bug_file_loc,short_desc,target_milestone,everconfirmed,product_id,component_id, reporter, delta_ts, estimated_time, remaining_time, deadline) VALUES ('1','PC','normal','P2','Linux','1','NEW','','รงรงรงรง','---','1','2','2',1, '2005-07-19 10:56:40.663303-03', 0, 0, NULL)"] at Bugzilla/DB.pm line 81 Bugzilla::DB::SendSQL('INSERT INTO bugs (version,rep_platform,bug_severity,priority,...') called at /var/www/localhost/htdocs/bugzilla/post_bug.cgi line 386 >From what I guess, it's trying to send the raw iso-8859-1 "c-cedilla" directly over a unicode connection. In PHP, I'd solve this using a simple pg_set_client_encoding() call, however I don't know the right way to do it under Perl. Can someone shed some light? Perhaps change database encoding to latin1? My system is all unicode (utf-8) here. -- Bruno Lustosa, aka Lofofora | Email: [EMAIL PROTECTED] Network Administrator/Web Programmer | ICQ: 1406477 Rio de Janeiro - Brazil | -- gentoo-user@gentoo.org mailing list