[rt-users] RT Attachment issue from 3.6.3 to 3.8.1

[Timothy Butkiewicz]

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: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Emmanuel
Lacour
Sent: Wednesday, October 15, 2008 3:18 AM
To: rt-users at lists.bestpractical.com
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.