Hello there, I run MySQL 4.1.12 and have some databases with the default collation of latin1_swedish_ci. I have edited the my.cnf file to read
default-collation = latin1_german1_ci Now I would like to change the collation on all existing databases, tables and columns to have the latin1_german1_ci collation, as the my.cnf entry only works for new entries. Is there an easy command or tool to achieve that? I don't want to send the appropriate command mentioning every single database, table and column, but rather look for a FOR loop or a wildcard. Thanks Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
