Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a MySQL table that has a number of columns with the latin1 character set. Because of driver issues, the columns actually contain utf8 data. I want to leave the data as-is but change the column character set to UTF8.

Every solution I've examined does two alter table commands, changing the column to binary, then back to the previous type with the new character set.

There are multiple columns on multiple tables in multiple databases, so this approach would be pretty slow.

Is there a better way to get this done?

share|improve this question

The fastest way may be just doing a mysqldump and import with specific flags set. Check this blog:

Some other alternative methods are listed here:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.