How to view or change database encoding

You can get the encoding for your database by the following steps. 

  1. Log into cPanel and click on the phpMyAdmin; icon.
  2. Click on your database name and the go to "Structure" tab.
  3. Here, you can see the "Collation" type under the column "Collation".

You can also change the Collation type by the following steps. 
  1. Go to "Operations" tab.
  2. At the bottom of the page you will see the collation option.

You can now select a collation from the drop down menu and click on the Go button.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to import / export MySQL database

The best way to import or export a database is via PHPMyAdmin.   There is a tab for Importing and...

How do I upload files?

You can upload your html and images to your website via FTP.    You will use the login specified...

Do you block any ports?

We have firewalls that block inbound and outbound ports, if you are having problems reaching...

I get weird characters on my WordPress blog

If you are using SuperCache with Wordpress, you need to make sure you disable compression or else...

How to change permissions on website files

Login to your Control Panel at www.yourdomain.com/cpanel using your cPanel username and...

Powered by WHMCompleteSolution