How to change MySQL database collation from phpMyAdmin in cPanel

Sometime you may require to change MySQL collation in your web hosting account to use foreign character encoding. There are many ways to change MySQL collation. Here are the steps to change MySQL collation from phpMyAdmin in cPanel:

[1] Login to your cPanel and click on “phpMyAdmin” icon.
[2] Click on your database name and the go to “Operations” tab.
[3] 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 the new collation will be set for new tables only. Old table will use the previous collation under which they were created. If you want to use new collation for already created tables, you will need to change collation for all tables.

5 Comments

  1. Avatar
    RiteshMay 9, 2009

    Hi,

    Thanks for the steps.

    Ritesh

    Reply
  2. Avatar
    maqsoodahmadAugust 6, 2009

    how i can change database on my site

    Reply
    1. Avatar
      kailashSeptember 19, 2009

      Are you referring to rename your MySQL database?

      Reply
  3. Avatar
    jay bharatDecember 11, 2009

    See if u want to use other then engish in your data base so u should have set Collation value as utf_char8 like p>???????? ?? ????????? ????????????? ?? ??????????????? ?? ?? ???????? ?? ???????? ??? ?? ????? ?? ?????? ??? ???? ?? ???? ?? ???? ?? ??. ?????? ???????? ?? ???? ?? ?? ???? ??? ??? ???? ???? ??????? ??? ???????? ??? ?????? ??.

    Above line reflected as same ooutput, but if u dont use utf_char8 as Collation then output become like this ?????? ??? ???? ???? ???

    Reply
  4. Avatar
    jay bharatDecember 11, 2009

    See if u want to use other then engish in your data base so u should have set Collation value as utf_char8 like p>???????? ?? ????????? ????????????? ?? ??????????????? ?? ?? ???????? ?? ???????? ??? ?? ????? ?? ?????? ??? ???? ?? ???? ?? ???? ?? ??. ?????? ???????? ?? ???? ?? ?? ???? ??? ??? ???? ???? ??????? ??? ???????? ??? ?????? ??.

    Above line reflected as same ooutput, but if u dont use utf_char8 as Collation then output become like this ?????? ??? ???? ???? ???

    Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to top
%d bloggers like this: