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