How can I view or change my 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.

Was this answer helpful?

 Print this Article

Also Read

How do I change the PHP timezone?

Our servers will be using the MST or GMT timezone, depending on the location of the server....

How do I block an IP address from reaching my website?

Please view our video tutorial at: http://www.cpanel.net/media/tutorials/ipdeny.htm  

How do I configure my MySQL databases?

Please view this video tutorial: http://www.cpanel.net/media/tutorials/addmysql.htm

How do I create a SSL certificate?

Let's be honest, creating SSL certificates can be confusing at times. Let us do the work for you...

How do I setup private nameservers?

Setting up private nameservers is fairly simple, however it all depends on where you registered...