Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

How can I change my MySQL database collation via phpMyAdmin?

Discussion in 'Database Discussion' started by dreamzgaurav, Jan 7, 2010.

  1. dreamzgaurav

    dreamzgaurav Registered

    Jan 6, 2010
    Likes Received:
    Trophy Points:

    How can I change my MySQL database collation?

    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:

    1. Enter your cPanel and click on the phpMyAdmin icon in the Databases box.

    2. Select the database you wish to manage from the drop-down menu on the left

    3. Click on the Operations tab in the top menu of your phpMyAdmin

    4. 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.

    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice