Home » Web Design and Development » Database » How to change database collation using phpmyadmin ?

How to change database collation using phpmyadmin ?

When you want to change the database collation of your database, the best thing you can do, change it using phpmyadmin. Since with phpmyadmin you can achieve the same using just one click.

  1. Login to your phpmyadmin account.

2. Select the appropriate database for which you want to change the collation from the left sidebar.

3. Click on “Operations” tab as you can see in below image,

This will open operations settings for your database, now you can see something like below showing your current collation settings. ( It can be different in your database)

Now, you can select the collation as you want from the dropdown. The most generally suitable collation is “utf8_general_ci” which we selected and clicked “Change all table collations” to change the settings for complete database tables.

Select something like below, and click “go” to change settings completely.

Rocket League - How To Change Langu...
Rocket League - How To Change Language (Epic Games)

1 thought on “How to change database collation using phpmyadmin ?”

Leave a Comment