Changing MySQL database collation Print

8

To overcome foreign character encoding issues you may change the MySQL collation in. Most obvious case of database collation is to change your MySQL collation from latin1 to utf8. With the help of using phpMyAdmin, you can do it by following:

Enter your cPanel and click on the phpMyAdmin icon available in the Databases box
Choose the database need to be managed from the drop-down menu on the left side
Click on the Operations tab in the topmost menu of your phpMyAdmin
At the very bottom side of the page collation option appears . Select a collation from the drop down menu and then click on the Go button.

Was this answer helpful?

Related Articles

Adding MySQL Access Hosts In Cpanel, a network administrator allows external web servers to access the MySQL database... Creating A MySQL Database In order to avail seamless database functionalities, administrators create highly effective... Grant User's Permission to database Once a network administrator creates a MySQL user, they must assign several permissions to those... How To Remove A MySQL Database Hosting experts suggest that you must remove any instance of MySQL from the server which are not... Removing A MySQL User In Cpanel In a scenario if you are not willing to delete the user from the database directly, you may...

« Back