Dev License: This installation of WHMCS is running under a Development License and is not authorized to be used for production use. Please report any cases of abuse to abuse@whmcs.com

Collation is a configuration level setting in the MySQL. It directs how the character data will be handled by the MySQL Database with in the server, database, or column level.

You can change the Database Collation using the SQL Commands as well as from GUI. Following are the steps to change the Collation for a Database in MySQL from phpMyAdmin.

Note: Consult your Database/Web Developer before making these changes.

  1. Log in to the phpMyAdmin.

  2. Select your Database and click on the Operations Button.

    select-database.png

  3. Select the required Collation from the Collation Drop-Down.

    collation-database.png

  4. Click on the Go Button.

You have changed the Database Collation successfully.

Was this answer helpful? 0 Users Found This Useful (0 Votes)

Most Popular Articles

What is parked domain?

Pointing one domain to another domain is called Domain Parking. Both Parked domain and Main...
How do I display Awstats publicly in Linux Shared Hosting?

There is no direct way of displaying statistics of your domain on your website, you can use the...
How to install MediaWiki in Linux hosting?

Pre-installation Steps: Set up MySQL database Please refer following article to set up MySQL...
How to Install OpenCart via Softaculous?

This tutorial will assist you to install OpenCart in your website through Softaculous....
Do you allow port scanning in any hosting plans?

No, we do not allow port scanning in any of our Web Hosting plans. Get Windows VPS

Powered by WHMCompleteSolution