[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


MySQL: Change collation for all tables

Posted on 2009-12-23
Medium Priority
Last Modified: 2012-06-27
I moved my database from one server to another server.  However in the process, the collation for all tables was changed from utf8_unicode_ci to utf8_general_ci

How can I change the collation back to utf8_unicode_ci for all tables?
Question by:hankknight

Assisted Solution

me655321 earned 500 total points
ID: 26112636

Accepted Solution

souquetbressand earned 1000 total points
ID: 26116208
Have you attempted simply using a SQL statement to change the collation?

LVL 14

Assisted Solution

profya earned 500 total points
ID: 26137249
If it is not a large database (too many records) then you can export it to a .sql file, replace the collation with any text editor and re-import it again.
If the number of tables is small, you can change the collation manually using phpMyAdmin/operations

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month18 days, 23 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question