Login
Menu

How To Change MySQL Database Collation?

Home / How To Change MySQL Database Collation?

How To Change MySQL Database Collation?

MySQL Database is called as a relational database management system that runs a server providing multi-user access to variety of databases. it’s a Free-software-open source project developed by a community of programmers with a full-featured database management system known as MySQL. Collation in MySQL Database may be a set of rules used in comparisons. As a result of many of us use MySQL with data to be stored in languages apart from English, they have to pick the rules of comparisons that successively depends on the character set which is used for storing that data. To resolve issues connected with foreign character encoding you usually change your MySQL collation. The foremost common technique to alter MySQL collation from latin1 to utf8 may be done by using phpMyAdmin and following the directions below:

  1.  Please Enter your cPanel hosting account login details and then click on the phpMyAdmin icon which is in the Databases box.
  2. The Database you wish to manage select it from the dropdown menu on the left.
  3. Then in the top menu of your phpMyAdmin click on the Operation tab.
  4. You will get the collation option at the bottom of the page. Now select a collection from dropdown menu and the click on the Go button.

Please make a notice of this issue, once you modify the collation of a database only the new tables can get created with the new collation and all other tables stay with the collation wherever they’re initially created. And because of convenience of the purchasers, most web hosts have set MySQL’s collation to utf8 by default. you’ll conjointly like this feature by joining OwnWebServers. the UK web hosting service provider offers reliable and secure hosting services from last decade to thousands of consumers with reliableness and security to run any on-line business.