Skip to content

Instantly share code, notes, and snippets.

@Teketel

Teketel/mysql_upgrade_to_utf8mb4.sql

Created February 15, 2018 13:58
Show Gist options
  • Save Teketel/6637b20fe5c1795a019d5a90e91f8d80 to your computer and use it in GitHub Desktop.
Save Teketel/6637b20fe5c1795a019d5a90e91f8d80 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_upgrade_to_utf8mb4.sql
ALTER DATABASE `<DB NAME>` CHARACTER SET = utf8mb4 COLLATE utf8mb4_unicode_ci;
SET foreign_key_checks = 0;
ALTER TABLE `<TABLE NAME>` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `<TABLE NAME>` CHANGE <COLUMN NAME> <COLUMN NAME> LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;
SET foreign_key_checks = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment