<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Sprechblasentext Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.SprechblasentextZchn
{mso-style-name:"Sprechblasentext Zchn";
mso-style-priority:99;
mso-style-link:Sprechblasentext;
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span lang=EN-US>Hello,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>we are running RT 3.8.7 (from Debian
Packages) together with PostgreSQL 8.4.1 in a German environment.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Unfortunalety, we cannot create tickets
from the Web Interface (both Quick Create an Full Create) when the subject
contains one of our German Special Characters like “ö” <i>and</i>
the Content is emtpy:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><img width=337 height=169 id="Bild_x0020_2"
src="cid:image001.png@01CAA00F.F00EB610"><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>As soon as I add something into the content
area, things work as expected. The same behavior can be observed in the regular
Ticket screen.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>The RT Log shows this, the text in curly
Brackets {} are the translations of the error messages from Postgres into
English. Note, that the F6 Character code “ö” in ISO-8859-1 and
consorts, which is the single-byte encoding in use here when Unicode is not
used.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>[Thu Jan 28 10:49:24 2010] [warning]:
DBD::Pg::st execute failed: FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«:
0xf6f6f60a {ERROR: Invalid Byte-Sequence for Encoding „UTF-8“}<o:p></o:p></span></p>
<p class=MsoNormal>HINT: Dieser Fehler kann auch auftreten, wenn die
Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet,
welche durch »client_encoding« bestimmt wird. at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. <span lang=EN-US>(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
{This error can also occur if the Byte-Sequence does not match with the
encoding expected by the server, set through “client_encoding”}<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>[Thu Jan 28 10:49:24 2010] [warning]:
RT::Handle=HASH(0x4cc00e8) couldn't execute the query 'INSERT INTO Attachments
(ContentType, Parent, Subject, Headers, Creator, MessageId, Created,
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x4cc00e8)', 'INSERT
INTO Attachments (ContentType, Parent, Subject, Header...', 'text/plain', 0,
'Test <F6><F6><F6>', 'MIME-Version: 1.0\x{a}X-Mailer:
MIME-tools 5.427 (Entity 5.427)\x{a}S...', 22, '', '2010-01-28 10:49:24', ...)
called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 357<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x4cc00e8)',
'Attachments', 'ContentType', 'text/plain', 'Parent', 0, 'Subject', 'Test
<F6><F6><F6>', 'Headers', ...) called at
/usr/share/perl5/DBIx/SearchBuilder/Handle/Pg.pm line 66<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0x4cc00e8)', 'Attachments',
'ContentType', 'text/plain', 'Parent', 0, 'Subject', 'Test
<F6><F6><F6>', 'Headers', ...) called at
/usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1293<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0x2c16a10)',
'ContentType', 'text/plain', 'Parent', 0, 'Subject', 'Test<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><F6><F6><F6>', 'Headers',
'MIME-Version: 1.0\x{a}X-Mailer: MIME-tools 5.427 (Entity 5.427)\x{a}S...',
...) called at /usr/share/request-tracker3.8/lib/RT/Record.pm line 289<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Record::Create('RT::Attachment=HASH(0x2c16a10)', 'TransactionId', 188101,
'Parent', 0, 'ContentType', 'text/plain', 'Headers', 'MIME-Version:
1.0\x{a}X-Mailer: MIME-tools 5.427 (Entity 5.427)\x{a}S...', ...) called at
/usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm line 143<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Attachment::Create('RT::Attachment=HASH(0x2c16a10)', 'TransactionId',
188101, 'Attachment', 'MIME::Entity=HASH(0x592b468)') called at /usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm
line 514<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Transaction::_Attach('RT::Transaction=HASH(0x2c10e30)',
'MIME::Entity=HASH(0x592b468)') called at
/usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line 154<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> RT::Transaction::Create('RT::Transaction=HASH(0x2c10e30)',
'ObjectId', 10150, 'ObjectType', 'RT::Ticket', 'TimeTaken', '', 'Type',
'Create', ...) called at /usr/share/request-tracker3.8/lib/RT/Record.pm line
1457<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Record::_NewTransaction('RT::Ticket=HASH(0x5929540)', 'Type', 'Create',
'TimeTaken', '', 'MIMEObj', 'MIME::Entity=HASH(0x592b468)', 'CommitScrips', 1,
...) called at /usr/share/request-tracker3.8/lib/RT/Ticket_Overlay.pm line 656<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Ticket::Create('RT::Ticket=HASH(0x5929540)', 'TimeEstimated', '', 'Status',
'new', 'Queue', 'RequestTracker', 'AdminCc', '', ...) called at
/usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 982<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::Commands::CreateTicket('Attachments', undef, 'TimeEstimated', '',
'Status', 'new', 'new-DependsOn', '', 'Queue', ...) called at
/usr/local/share/request-tracker3.8/html/Ticket/Display.html line 117<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US>If you need any more information, please let me know.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US>Thanks in advance,<br>
Torben Nehmer</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:7.5pt'>-------<br>
Torben Nehmer<br>
Diplom Informatiker (FH)<br>
Business System Developer</span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:7.5pt'>CANCOM Deutschland GmbH<br>
Messerschmittstr. 20<br>
89343 Scheppach<br>
Germany</span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:7.5pt'>Tel.: +49 8225 - 996-1118<br>
Fax: +49 8225 - 996-41118<br>
</span><span style='font-size:12.0pt'><a href="mailto:torben.nehmer@cancom.de"><span
lang=EN-US style='font-size:7.5pt;color:blue'>torben.nehmer@cancom.de</span></a></span><span
lang=EN-US style='font-size:10.0pt'><br>
</span><span style='font-size:10.0pt'><a href="http://www.cancom.de"><span
lang=EN-US style='font-size:7.5pt;color:blue'>www.cancom.de</span></a></span><span
lang=EN-US style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:7.5pt'>CANCOM Deutschland GmbH<br>
Sitz der Gesellschaft: Jettingen-Scheppach<br>
HRB 10653 Memmingen<br>
<span style='color:black'>Geschäftsführer: Paul Holdschik, Christian
Linder</span></span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt'>Diese E-Mail und alle
mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch
durch den Empfänger bestimmt! <br>
</span><span lang=EN-US style='font-size:7.5pt'>This e-mail and any files
transmitted with it are confidential intended solely for the use of the
addressee!</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</body>
</html>