jeb wrote: > Hi all, > > I have a MySQL DB in my production environment with collation set to > latin1_swedish_ci
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 properly. > > 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 > utf8? > You really *should* alter the table to UTF8. That way you'll be able to handle any conceivable character. > > Any idears? Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
