I have a MySQL DB in my production environment with collation set to
This is not a Rails question; it is a MySQL question. You'll get better
answers in a MySQL forum. But...
My recollection is that not just the DB but also each table and each
field in MySQL can have its own sort order. Make sure these are all set
When I do a simple find and order by 'name' the names are not sorted
in Swedish order. They are "Anna, �sten, Kalle, Rut" when they should
be "Anna, Kalle, Rut, �sten".
I guess a simple sort shall work without having to alter the table to
You really *should* alter the table to UTF8. That way you'll be able to
handle any conceivable character.