Server Gigabit Guide

Changing Collation in PhpMyAdmin

You are here:
Estimated reading time: 1 min

Step of Changing Collation in PhpMyAdmin

Sometime, you may found out MySQL database collation might not set to the correct collation after restore your database to the server, however you may change the collation type through PhpMyAdmin.

You may refer to the step as below on how to change collation:

1. Login to your phpMyAdmin, you may see the collation type from your right panel.

2. Select your database from left hand panel, select on the structure(second icon) from Action tab, checked the checkbox of the database filed that you wish to change the collation and click on the change (Pencil icon).

3. You are allow to change the collation of the database field.

4. Click on the Operation from the top, you are allow to change the collation for the database tables.

 

Please refer to the following article to know more. 
Knowledge Base: Clone database using PhpMyAdmin

Was this article helpful?
Dislike 0
Views: 60