Collation is a configuration level setting in MySQL which directs how the MySQL Database will handle the character data within the server, database, or column level. You can change the Database Collation using the SQL Commands from GUI.
The steps listed below can be implemented to change the Collation for a Database in MySQL from phpMyAdmin –
Note: Consult your Database/ Web Developer before making these changes.
1. Log in to phpMyAdmin.
2. Select your Database and click on the Operations button.
3. Select the required Collation from the Collation Drop-Down.
4. Click on the Go button.
You have changed the Database Collation successfully!