HOW TO: Change the MySQL collation settings in phpMyAdmin
Posted by on 03 July 2018 01:40 PM
|
|
This article describes how to use phpMyAdmin to change the collation settings for MySQL databases and tables. ABOUT CHARACTER SETS AND COLLATIONMySQL 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. CHANGING THE DEFAULT COLLATION FOR A DATABASETo change the default collation for a database, follow these steps:
CHANGING THE COLLATION FOR A TABLETo change the collation for a database table, follow these steps:
MORE INFORMATIONFor more information about character sets and collation in MySQL, please visit https://dev.mysql.com/doc/refman/5.5/en/charset-general.html. | |
|