Wednesday, August 24, 2011

How to change MySQL database collation?

October 21, 2009 by  
Filed under cPanel


Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below:

  • Enter your cPanel and click on the phpMyAdmin icon in the Databases box.
  • Select the database you wish to manage from the drop-down menu on the left
  • Click on the Operations tab in the top menu of your phpMyAdmin
  • At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.

Please note that after your change the collation of a database only the new tables will be created with the new collation. All other tables remain with the collation, they were initially created.

For the convenience of their customers, most web hosts have set MySQL’s collation to utf8 by default.

GD Star Rating
a WordPress rating system
Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Related posts:

  1. MySQL database import-export from Shell
  2. Fastest way to install WordPress is through cPanel
  3. How to install SSL certificate
  4. Default (catchall) email address setup in cPanel
  5. Installing PostgreSQL on cPanel/WHM Server


2 Responses to “How to change MySQL database collation?”
  1. payday loans says:

    The author of has written an excellent article. You have made your point and there is not much to argue about. It is like the following universal truth that you can not argue with: Everyone always remembers the day a dog ran into your school. Thanks for the info.

    GD Star Rating
    a WordPress rating system


Check out what others are saying about this post...
  1. ensim says:

    [...] Ensim – 2,156 Views. What is Alexa Ranking? – 2,070 Views. Choosing A Scripting Language For …How to change MySQL database collation? : Control Panel BlogEnsim. General. Helm. HyperVM. LxAdmin/Kloxo. Plesk. Webmin. You are here: Home / cPanel / How to [...]


Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!
Click here to cancel reply.