MySQL Collation

You can use phpMyAdmin to alter the collation of mySQL databases,

    1. In cPanel, select the phpMyAdmin icon in th Databases subsection.
    2. Choose the database that you would like to modify from the drop down menu on the left side of the page.
    3. Select the "Operations" tab.
    4. The collation option will be at the bottom of the page. Using the dropdown menu, you can choose how the database is collated.



Note: Only new tables will be created with the collation you have chosen - old tables will not be modified. To get around this, re-install or edit the tables and their individual fields. Newly saved databases will have their collation changed.

  • 50 Users Found This Useful
Was this answer helpful?

Related Articles

Do you offer password protected directories?

By default, cPanel allows you to password protect directories in your account that you wish to...

Why can't I log into my cpanel or webmail?

There various issues that you may not be able to login to your cPanel or WebMail. We have...

Custom Error Pages

Creating your own error pages can be accomplished through cPanel. After logging in, under...

Requesting a New cPanel Password

Resetting Your cPanel PasswordYou can reset your cPanel password from the cPanel login screen....

Secure cPanel Login

Using Shared SSL to Access cPanel Use https, enter your site's IP address, and the secure port...