MarcosBL
10/27/2014 - 12:58 AM

Converting MySQL Database Contents to UTF-8

Converting MySQL Database Contents to UTF-8

# Do a loop with your database tables that creates commands like this, it will force the conversion automatically

ALTER TABLE `name` MODIFY COLUMN `title` VARCHAR(255) CHARACTER SET binary;
ALTER TABLE `name` MODIFY COLUMN `title` VARCHAR(255) CHARACTER SET utf8;