Changing database character set and collation
You can change the character set and collation of your databases and tables through phpMyAdmin or from the command line. You may want to back up your database before making changes. Please see this article for instructions: Export and import MySQL databases.
phpMyAdmin
- Log into phpMyAdmin.
- Select your database from the list on the left.
- Click on "Operations" from the top set of tabs.
- In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation.
- Select your database from the list on the left.
- Click on "Operations" from the top set of tabs:
- In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation.
- Click Go.
- To update a database table, select it from the list on the left.
- Click on "Operations" from the top set of tabs.
- In "Table options," under "Collation," choose your new collation from the dropdown menu.
- Click Go.
