[rt-users] Issue with iso/utf in 3.8.1?

[Emmanuel Lacour]

On Wed, Aug 20, 2008 at 05:20:44PM +0200, Geir Skjotskift wrote:
> Emmanuel Lacour wrote:
> > You're using mysql, right?
> > 
> > Did you run the schema.mysql-4.0-4.1 upgrade ?
> 
> 
> using mysql yes.
> 
> I ran the 
> 
> "/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade" 
> 
> and specified 3.8.0 as "upgrade from" and it said no database updates from 3.8.0
> 
> I did the upgrade from 3.6.1 -> 3.8.0 three days ago, and did the same thing. 
> It made (apparently) a lot of changes to the db at that run.
> 

You forgot to read UPGRADING.mysql. It will tell you to upgrade format
of DB fields as now RT uses full UTF-8 colation.

Just run the steps related to schema.mysql-4.0-4.1 (make a backup
before!) and you're non ascii chars will be back :)