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