MySQL Collating

Using phpMyAdmin you can change the collation of databases.

  1. In cPanel, click the phpMyAdmin icon.
  2. Choose the database you wish the alter from the dropdown menu.
  3. Select the "Operations" tab.
  4. Find the collation option. You can change the collation from the dropdown menu.

Note: This will only affect new tables created after the collation change. To get around this problem, re-install or edit old tables and their fields. Anything installed will pick up the new collation.

  • 28 Users Found This Useful
Was this answer helpful?

Related Articles

Is it a problem if I'm not in the US?

Not at all! In fact, we already have customers in countries all over the world.

I uploaded my page but it's not working!

Make sure that you are uploading to the public_html or www folder.  Only the files placed...

What is an error 404 page?

Error 404 indicates that you are requesting a file or a directory that does not exist on the...

Can I run scripts like Wordpress, Joomla, or phpBB on my site?

Absolutely! We make it extremely easy to install over 250 different scripts via the Softaculous...

Can I upgrade my plan or features later?

Upgrades/Addons are available to purchase at any time through your Client Area dashboard. Once...