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 3776