Skip to content

Instantly share code, notes, and snippets.

@taross-f

taross-f/convert_utf8.sql

Created February 14, 2017 10:40
Show Gist options
  • Save taross-f/853e5e216e3fe0d28813f76539446421 to your computer and use it in GitHub Desktop.
Save taross-f/853e5e216e3fe0d28813f76539446421 to your computer and use it in GitHub Desktop.
Download ZIP
convert all columns to UTF8 characterset on Mysql
Raw
convert_utf8.sql
select concat("alter table schema.", table_name, " convert to Character set utf8;")
from information_schema.TABLES
where table_schema = "schema";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment