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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com