Converting MySQL tables to utf8 encoding format

How to convert MySQL tables to utf8 encoding format?

Solution:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

If you already have MySQL database dump containing characters written in some other character encoding type the solution would be this:

alter table TABLE_NAME modify FIELD_NAME blob;
alter database DATABASE_NAME charset=utf8;
alter table TABLE_NAME modify FIELD_NAME varchar(255) character set utf8;

This forces MySQL to convert the binary format into varchar using character set utf8.

Related Posts:

• Useful MySQL Cheat Sheet
• Free MySQL database management tool for Mac OS X
• Import Large MySQL Databases into PHPMyAdmin
• Database solution for scalability and high availability
• Useful MySQL commands

Tagged as: Databases, Learn, MySQL