Can we clarify this? The UPGRADING.mysql seems to allude to the fact that latin1 should be used instead of utf8. The schema says utf8, but the docs appear to say something else. I too am having issues with attachments.
UPGRADING.mysql reads: * don't use utf8 as default mysql's character set, it's default in some Distributives If you still want to make upgrade of mysql and RT at once, then you can do the following: 4) Configure mysql 4.1 and newer to use latin1 as default character set everywhere. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Lacour Sent: Wednesday, October 15, 2008 3:18 AM To: [email protected] Subject: Re: [rt-users] RT Attachment issue from 3.6.3 to 3.8.1 On Wed, Oct 15, 2008 at 01:34:28PM +1100, Chamara Peris wrote: > Hi All, > ) ENGINE=InnoDB AUTO_INCREMENT=31223 DEFAULT CHARSET=latin1 | Is this the statement after upgrade or on your fresh 3.8.1 install? RT >= 3.8.1 uses UTF-8, you seems to have the wrong charset. If it's the stetement after upgrade, then you missed reading UPGRADING.mysql. If it's a fresh 3.8.1 install, how did you create your tables? If using rt-setup-database, this should be UTF-8, if using somethink like "cat schema.mysql | mysql rt", then this would be because you're default is latin1. _______________________________________________ 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
