<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Hey. </FONT></DIV>
<DIV><FONT face=Arial size=2>I'm having some charset trouble with rt3.0.2pre6
and postgresql.</FONT></DIV>
<DIV><FONT face=Arial size=2>In general, international characters seems to
work, but during testing I forwarded an email into the rt system, and got the
following errors:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[Thu May 22 08:59:51 2003] [debug]: Converting
'iso-8859-1' to 'utf-8' (/opt/rt3/lib/RT/I18N.pm:211)<BR>[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.<BR> (/opt/rt3/lib/RT.pm:226)<BR>[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.<BR> (/opt/rt3/lib/RT.pm:226)<BR>[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.<BR> (/opt/rt3/lib/RT.pm:226)<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>Marcus </DIV></FONT></FONT></DIV></BODY></HTML>