[rt-users] Attachments and unhappiness

[Brian Gallew]

So, I've figured out the attachment issue: not only much the attachments 
table default to the latin1 charset, but your CONNECTION must also be in 
latin1 mode.  In my environment, the mysql (5.0.24a) server (on another 
host) defaults everything to utf8, while the RT installation is using 
mysql-4.0.25, which completely fails to set the connection type based on 
the contents of /etc/my.cnf.  I was able to fix the problem by applying 
the patch at the end. 

--- RT.pm.orig  2007-03-08 11:49:10.000000000 +0300
+++ RT.pm       2007-03-08 11:38:54.000000000 +0300
@@ -203,6 +203,7 @@
         $Handle = RT::Handle->new();
     }
     $Handle->Connect();
+    $Handle->SimpleQuery("SET NAMES 'latin1'");
 }
 
 =head2 InitLogging