Hey.
I’m having some charset trouble with rt3.0.2pre6 and postgresql.
In general, international characters seems to work, but during testing I forwarded an email into the rt system, and got the following errors:
[Thu May 22 08:59:51 2003] [debug]: Converting ‘iso-8859-1’ to ‘utf-8’ (/opt/rt3/lib/RT/I18N.pm:211)
[Thu May 22 08:59:52 2003] [warning]: DBD::Pg::st execute failed: ERROR: Invalid UNICODE character sequence found (0xe56e65) at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 386.
(/opt/rt3/lib/RT.pm:226)
[Thu May 22 08:59:52 2003] [warning]: RT::Handle=HASH(0x840278c) couldn’t execute the query ‘INSERT INTO Attachments (Subject, ContentType, Filename, Headers, Creator, Parent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 393.
(/opt/rt3/lib/RT.pm:226)
[Thu May 22 08:59:52 2003] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/share/perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 386.
(/opt/rt3/lib/RT.pm:226)
This results in a ticket being created without a queue… Even if there was invalid unicode characters in the mail, this seems to be a bug? (This is with the latest DBIx::SearchBuilder)
Marcus