<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)">
<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:12.0pt;
font-family:"Times New Roman","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;}
span.apple-style-span
{mso-style-name:apple-style-span;}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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="1026" />
</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 style='word-wrap: break-word;-webkit-nbsp-mode: space;
-webkit-line-break: after-white-space'>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Jesse,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:70.8pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>The
second problem I have tested so far only with the RT Standalone server, I
cannot say anything (yet) for other ways to run RT as I’m still in the
process of testing everything.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:70.8pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:70.8pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'>At
least Debian MySQL 5.0.51a does by default initialize all connections in latin1
mode. So after converting the Database to correct UTF-8, MySQL does
automatically convert any columns known as UTF-8 into the default connection
charset latin1. This leads to all broken non-ASCII Chars all over the site
except the Attachments (where RT itself appearantly does the conversion
handling, as this is a BINARY field).<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:35.4pt'><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:35.4pt'><span lang=EN-US>How long has
MySQL done that? I've never experienced it. Regardless, I've opened a ticket
for this as well.<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 style='font-family:"Calibri","sans-serif";
color:#1F497D'>I am not sure which MySQL Versions actually show this behavior.
I suspect that it has to do with the actual Debian based installation I am
using here. Maybe the MySQL System is forced to some charset or doesn’t
correctly honor the locale, maybe it is even a bug. I cannot tell for sure,
unfortunalety.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Calibri","sans-serif";
color:#1F497D'>Independent of this I think it is better to be safe than sorry,
as the saying goes. <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><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Thanks again for the report.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>No problem, please tell me if you need additional information
and / or Tests regarding this problem. My RT 3.8 installation is still in
testing, so doing all kinds of experimental Stuff is no problem. I’m
waiting for 3.8.1 to go productive here ;-)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Greetings
from Germany,<br>
Torben Nehmer</span><span style='color:#1F497D'><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;font-family:"Arial","sans-serif";color:#1F497D'>-------<br>
Torben Nehmer<br>
Diplom Informatiker (FH)<br>
Business System Developer</span><span style='color:#1F497D'><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;font-family:"Arial","sans-serif";color:#1F497D'>CANCOM
Deutschland GmbH<br>
Messerschmittstr. 20<br>
89343 Scheppach<br>
Germany</span><span style='color:#1F497D'><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;font-family:"Arial","sans-serif";color:#1F497D'>Tel.:
+49 8225 - 996-1118<br>
Fax: +49 8225 - 996-41118<br>
</span><span style='color:#1F497D'><a href="mailto:torben.nehmer@cancom.de"><span
lang=EN-US style='font-size:7.5pt;font-family:"Arial","sans-serif";color:blue'>torben.nehmer@cancom.de</span></a></span><span
lang=EN-US style='font-size:10.0pt;color:#1F497D'><br>
</span><span style='font-size:10.0pt;color:#1F497D'><a
href="http://www.cancom.de"><span lang=EN-US style='font-size:7.5pt;font-family:
"Arial","sans-serif";color:blue'>www.cancom.de</span></a></span><span
lang=EN-US style='color:#1F497D'><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;font-family:"Arial","sans-serif";color:#1F497D'>CANCOM
Deutschland GmbH<br>
Sitz der Gesellschaft: Jettingen-Scheppach<br>
HRB 10653 Memmingen<br>
</span><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:black'>Geschäftsführer: Paul Holdschik, Christian Linder</span><span
style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:#1F497D'>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;font-family:"Arial","sans-serif";
color:#1F497D'>This e-mail and any files transmitted with it are confidential
intended solely for the use of the addressee!</span><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Jesse Vincent
[mailto:jesse@bestpractical.com] <br>
<b>Gesendet:</b> Sonntag, 27. Juli 2008 02:15<br>
<b>An:</b> Torben Nehmer<br>
<b>Cc:</b> rt-users@lists.bestpractical.com<br>
<b>Betreff:</b> Re: [rt-users] MySQL related Bugs in RT 3.8 while Upgrading
from 3.6<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal>On Jul 24, 2008, at 2:58 AM, Torben Nehmer wrote:<o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
<div>
<div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'>Hi there,</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'> </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'>I have been testing the upgrade of our (originally Debian Based)
RT 3.6.5 installation to RT 3.8 and found two bugs in the process:</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'> </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'>First, the script generating the necessary code to convert the
Database from MySQL 4.0 to 4.1 and newer produces corrupt SQL at least in my
case here. It has several occurrences of constructs like this:</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'> </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Thank you. I've opened a ticket for this.<o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
<div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#144FAE'> </span></span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'>The second problem I have tested so far only with the RT
Standalone server, I cannot say anything (yet) for other ways to run RT as
I’m still in the process of testing everything.</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'> </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:black'>At least Debian MySQL 5.0.51a does by default initialize all
connections in latin1 mode. So after converting the Database to correct UTF-8,
MySQL does automatically convert any columns known as UTF-8 into the default
connection charset latin1. This leads to all broken non-ASCII Chars all over
the site except the Attachments (where RT itself appearantly does the
conversion handling, as this is a BINARY field).</span><span style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:black'><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>How long has MySQL done that? I've never experienced it.
Regardless, I've opened a ticket for this as well.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Thanks again for the report.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Jesse<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>