Knowledgebase: MySQL
Change the Collation of a MySQL Database
Posted by ASO Admin on 21 February 2020 12:01 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 

  5. In the Collation section on the right select your desired collation from the drop-down menu

  6. Click the 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



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

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