Skip to content

Instantly share code, notes, and snippets.

@MarcosBL

MarcosBL/converting-mysql-database-contents-to-utf8

Created October 27, 2014 00:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save MarcosBL/dbbed084573e3d87b70a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save MarcosBL/dbbed084573e3d87b70a to your computer and use it in GitHub Desktop.
Download ZIP
Converting MySQL Database Contents to UTF-8
Raw
converting-mysql-database-contents-to-utf8
# 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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment