This article describes how to use phpMyAdmin to change the collation settings for MySQL databases and tables.
MySQL enables you to store and process data in a wide variety of languages using various character sets. For some operations, such as comparing two strings, MySQL uses a set of rules to determine equality and sorting order. This set of rules is known as a collation.
You may have to change the collation for a database or table based on the character set you want to use for string data. You can do this by using the phpMyAdmin tool in cPanel.
To change the default collation for a database, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click phpMyAdmin:
Under Collation, select the collation that you want for the database, and then click .
To change the collation for a database table, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click phpMyAdmin:
For more information about character sets and collation in MySQL, please visit https://dev.mysql.com/doc/refman/5.5/en/charset-general.html.
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.
We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.