this is a double upstream issue (mysql default), but the default collation for mysql is latin1_swedish_ci. it seems like latin1_general_ci would make a lot more sense since all the other charsets use the general collation. it is easy to fix in my.cnf: collation_server=latin1_general_ci does anyone else think this is worth whining at mysql or redhat about?