Skip to content

Instantly share code, notes, and snippets.

@ivanoronee

ivanoronee/update_mysql_to_use_utf8mb4

Created January 23, 2017 08:56
Show Gist options
  • Save ivanoronee/7a71998d2055e9fbf26800e1ac9fb3f7 to your computer and use it in GitHub Desktop.
Save ivanoronee/7a71998d2055e9fbf26800e1ac9fb3f7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update_mysql_to_use_utf8mb4
ALTER DATABASE <database_name> CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
SET GLOBAL innodb_file_format = barracuda;
set global innodb_large_prefix=on;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment