Development
Nov 1, 2008
Vision4Web
20 Comments

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

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.

20 Comments

  • nauhchij December 18, 2010 at 9:53 am

    wow it was soooo handy~
    thanks a lot~!!
    =)

  • Fabregus March 21, 2011 at 3:10 am

    Thank you very much!It was really helpful!

  • Fatahian May 28, 2011 at 9:29 am

    Great & very useful script.

    thank you so much.

  • Akbar May 30, 2011 at 6:03 am

    I LOVE IT!!!

  • sudath September 23, 2011 at 6:02 am

    Great article . this is the tool i search.

  • sunshine September 25, 2011 at 12:13 am

    extremly life and time saver please spread the word all over the net

    sincere thanks to the publisher

  • Boaz October 31, 2011 at 12:57 am

    Wow, thanks! this saved me hours of work!

  • Shailendra December 4, 2011 at 12:18 pm

    Thanks!!! it saved my lot of time….

  • ahmad balavipour December 18, 2011 at 1:52 pm

    Thanks alot, very good code

  • JoeW January 29, 2012 at 12:54 pm

    Perfect! So simple yet so very effective. That saved me around 4hrs work, many thanks!

Leave a comment