How to change the collation for the particular table using phpMyAdmin?

If your database displays garbled characters or encoding errors, the collation of one or more tables may need to be changed. phpMyAdmin lets you update the collation for individual tables.

Steps to Change Table Collation

1. Log in to your cPanel account.
2. Navigate to the Databases section and click phpMyAdmin.
3. In the left-hand panel, click the database that contains the table you want to modify.
4. Click the table name to select it (the table contents will be displayed).
5. Click the Operations tab at the top of the page.
6. Under Table options, locate the Collation drop-down menu.
7. Select the desired collation (e.g. utf8mb4_general_ci for modern Unicode support, or utf8mb4_unicode_ci for more accurate sorting).
8. Click Go in the Table options section. A confirmation message will appear once the collation is updated.

Important Notes

• Changing a table’s collation does not automatically convert existing data. If your data is already corrupted, you may also need to convert the column collations individually.
• utf8mb4 is the recommended character set for modern applications as it supports the full Unicode range (including emojis). The older utf8 (3-byte) is a legacy option.
• The database itself should have a matching collation. You can set the database collation from the Operations tab of the database (not the table).

Troubleshooting

• Characters still garbled after change: The data itself may have been stored with incorrect encoding. You may need to convert the data using an SQL query such as ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
• Collation drop-down is missing: Make sure you are on the Operations tab of the table (not the database). The table must be selected first.