Knowledgebase: MySQL
Change the Collation of a MySQL Database
Posted by H9 Admin on 31 March 2015 12:12 PM

You can change the collation of a MySQL database by using phpMyAdmin:

  1. Log into cPanel
  2. Click PHPMyAdmin, from the Databases section


  3. In the Recent Tables menu in the left sidebar, click the name of the database you want to manage from the drop-down menu

  4. Click the Operations tab, near the top of the page

    Operations tab

  5. In the Collation section on the right select your desired collation from the drop-down menu
  6. Click the Go button​

    Go button

After you change the collation of a database, only the newly-created tables will be created with the new collation specification. Old tables remain collated as they originally were. You can get around this in PHPMyAdmin:

  1. While in PHPMyAdmin in cPanel, select the database you want to manage from the drop-down in the Recent Tables sidebar

  2. Check which collation is set via the Collation section

  3. Re-install the old tables, or simply edit the tables and their individual fields; anything you install will pick up that new collation specification, for the table and individual fields

 gobutton.png (35.93 KB)
 operations.png (71.14 KB)
 phpmyadmin.png (19.22 KB)
(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
Full Name:
Help Desk Software by Kayako fusion