315535 - DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UNICODE": 0xe7e36f

Status: RESOLVED WORKSFORME

(Bugzilla :: Database, defect)

Description

[Sidnei Mistura]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FDM)
Build Identifier: DBD::Pg::db do failed: ERROR:  invalid byte sequence for encoding "UNICODE": 0xe7e36f

Software error:
DBD::Pg::db do failed: ERROR:  invalid byte sequence for encoding "UNICODE": 0xe7e36f
 [for Statement "INSERT INTO longdescs
                      (bug_id, who, bug_when, thetext, isprivate, work_time)
               VALUES (?,?,?,?,?,?)"] at Bugzilla/Bug.pm line 720
	Bugzilla::Bug::AppendComment(2, 2, 'Teste de Acentua\x{e7}\x{e3}o', 'undef', '2005-11-08 08:08:18.328-03', 'undef') called at G:/Bugzilla/process_bug.cgi line 1369


Reproducible: Always




DBD::Pg::db do failed: ERROR:  invalid byte sequence for encoding "UNICODE": 0xe7e36f
 [for Statement "INSERT INTO longdescs
                      (bug_id, who, bug_when, thetext, isprivate, work_time)
               VALUES (?,?,?,?,?,?)"] at Bugzilla/Bug.pm line 720
	Bugzilla::Bug::AppendComment(2, 2, 'Teste de Acentua\x{e7}\x{e3}o', 'undef', '2005-11-08 08:08:18.328-03', 'undef') called at G:/Bugzilla/process_bug.cgi line 1369

Comment 1

[Emmanuel Seyman]

Several questions :

What version of PostgreSQL are you using?
What version of Bugzilla are you using?

Are the two characters that you are trying to insert a a c with a cedilla and
an a with a tilde ?

Comment 2

[Sidnei Mistura]

Answering the Questions:

- What version of PostgreSQL are you using?
R: 8.0

- What version of Bugzilla are you using?
R: Version 2.20 

- Are the two characters that you are trying to insert a a c with a cedilla and
  an a with a tilde ?
R: Any caracter accented this problem is happening.

Comment 3

[Emmanuel Seyman]

(In reply to comment #2)
> 
> R: Any caracter accented this problem is happening.

Interesting. I can't reproduce this using the same version of PostgreSQL and the same version of Bugzilla (on Linux).

Comment 4

[Sidnei Mistura]

I carried through a test, I made a manual INSERT with the accented characters and inserted normally.

Comment 5

[Olav Vitters]

Could you make the changes as documented at: http://www.bugzilla.org/docs/2.20/html/security-bugzilla.html

then try again using bugzilla

Comment 6

[Max Kanat-Alexander]

Sidnei: What version of DBD::Pg and DBI are you using?

When you look at the database list (the "\l" command) in the psql client, what "encoding" does the Bugzilla database have?

Comment 7

[Sidnei Mistura]

(In reply to comment #5)
> Could you make the changes as documented at:
> http://www.bugzilla.org/docs/2.20/html/security-bugzilla.html
> 
> then try again using bugzilla
> 

Ok, with these alterations functioned legal, is thankful.

Comment 8

[Emmanuel Seyman]

(In reply to comment #7)
>
> Ok, with these alterations functioned legal, is thankful.

This indicates that Pg doesn't accept non-UTF-8 text if the database has been created with that encoding. This reads more like a documentation bug (you should force the charset if you're using Pg as a database) more than anything else. Any objections to my changing the component (and filing a patch) ?

Comment 9

[Frédéric Buclin]

Bugzilla now encodes everything using UTF8 by default.