Changing MySql database character set and collation in PHPMyadmin

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

  1. Log into phpMyAdmin.
  2. Select your database from the list on the left.
  3. Click on "Operations" from the top set of tabs.
  4. In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation.
  5. Select your database from the list on the left.
  6. Click on "Operations" from the top set of tabs:

  7. In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation.

  8. Click Go.
  9. To update a database table, select it from the list on the left.

  10. Click on "Operations" from the top set of tabs.

  11. In "Table options," under "Collation," choose your new collation from the dropdown menu.

  12. Click Go.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Connection Strings (MSSQL 2005, MSSQL 2008, MySQL5, MS Access Database)

MSSQL2005Set conn = Server.CreateObject("ADODB.Connection")conn.Open "Provider=SQLOLEDB; Data...

How do I use an Access database on my site?

Microsoft Access is part of the Microsoft Office suite of applications and is a database that is...

Import Export MySQL database using PhpMyAdmin

Do the following steps for import/export mysql database: Open phpMyAdmin.by going to...

What is MySQL?

MySQL is an open source database server, much like Microsoft SQL Server or Oracle. You can store...