Skip to content

Instantly share code, notes, and snippets.

@sjava

sjava/convert_utf8_to_utf8mb4

Forked from dschneider/convert_utf8_to_utf8mb4
Created September 25, 2018 16:21
Show Gist options
  • Save sjava/27daf2fcdac52f7928733352c8cf1e94 to your computer and use it in GitHub Desktop.
Save sjava/27daf2fcdac52f7928733352c8cf1e94 to your computer and use it in GitHub Desktop.
Download ZIP
How to easily convert utf8 tables to utf8mb4 in MySQL 5.5
Raw
convert_utf8_to_utf8mb4
# For each database:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# For each column:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment