How to Convert a DB to UTF8 in MySQL
- 1). Log in to your MySQL account. Access the query tool.
- 2). Type in the following query:
ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci
This query says that you want to change the current collation of the database provided by "dbname" from whatever it currently is to UTF8. - 3). Execute the query.