Sunday, February 6, 2011

How do I change the character set in a MySQL database?

To change the character set in a MySQL database, please refer to the following:

  1. Login to your Control Panel.
  2. Click Hosting.
  3. Choose Databases.
  4. Click MySQL.
  5. For the database you wish to administer click the phpMyAdmin link.
  6. Click your database name (eg. looks something similar to d########).
  7. Click the SQL tab.
  8. Enter the following query to change to utf-8 (replace [databaseid] with your database name):