Knowledgebase

MySQL provides the flexibility to store and process data in different languages using various character sets. When it comes to comparing strings or determining sorting order, MySQL relies on a set of rules known as collation.

To change the collation for a database, follow these steps:

1. Log in to cPanel by following the guide in Accessing cPanel.
2. Open phpMyAdmin:                                                                                                                                                                  
3. In the left pane, select the database you want to modify.
4. Click on the "Operations" tab in the top menu bar.
5. Under "Collation," choose the desired collation for the database.
6. Click "Go" to save the changes.

It's important to note that changing the default collation for a database only affects new tables. Existing tables will maintain their current collation setting.

To change the collation for a specific table, follow these steps:

1. Log in to cPanel.
2. Open phpMyAdmin:                                                                                                                                                                        
3. In the left pane, expand the view of the database that contains the table you want to modify.
4. Click on the name of the table.
5. Click on the "Operations" tab in the top menu bar.
6. Under "Table options," select the desired collation from the "Collation" list box.
7. Click "Go" to save the changes.

By following these steps, you can easily change the character sets and collation in MySQL for your databases and tables.