Skip to content

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.

Posted in Development. Tagged with , , , , , , , , , , , .

By Nebojsha Milosavlevski
November 1, 2008

8 comments

8 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

  1. Murali Krishna K said
    on November 21, 2008

    Hi, Nebojsha Milosavlevski,

    Thanks for sharing the beautiful link, which saved a day of my time.

  2. Ethan Russell said
    on February 12, 2009

    Thanks a lot, this is a very handy little tool indeed!

  3. nerozero said
    on May 20, 2009

    Many thanks to you!!!!

  4. DeJaaaN said
    on June 28, 2009

    I need this so much. tnx a lot!

  5. onasre said
    on August 1, 2009

    thank you >>> very very usefull script

  6. John said
    on August 5, 2009

    You saved my life

  7. sewEstins said
    on October 9, 2009

    Любопытно, а есть хоть кто-то, кто не согласен с автором?

Continuing the Discussion

Some HTML is OK

(required)

(required, but never shared)

or, reply to this post via trackback.

Travel2Macedonia.com.mk - National traveling & tourism portal