MYSQL Change Collation On All Tables And Columns In MySQL with Phoca Changing Collation Utility

Dec 11, 2008 Author: City Hall

I was working with lot of databases collated in latin1_swedish_ci lately. I needed to convert the structure to utf8 collation, but it was very time-consuming to convert all the tables and all the columns manually.

After some googling, I managed to find a PHP utility, called Phoca Changing Collation, which does all the dirty work in a few seconds.

Important: The utility doesn’t convert data, it only changes the collation of the tables and the columns, so if your database is full of non-latin characters, it will probably corrupt them.

Note: You may need to change the collation to utf8_unicode_ci in order to get the cyrilic characters displayed propertly.


views 11198
  1. Add New Comment