All my database tables are MyISAM, and the collation for each is latin1_general_ci. I was thinking about switching to a popular CMS and was playing around with WordPress and Drupal. I discovered that both use InnoDB tables, with utf8_general_ci for collation.
Even if I’m not able to switch to a CMS, I’m wondering if there would be an advantage to switching to InnoDB and utf8_general_ci anyway. Is there a command I can type into phpMyAdmin > SQL that will change all my settings to InnoDB, utf8_general_ci, or do I have to do it one table at a time?
Thanks.