Skip to content

Instantly share code, notes, and snippets.

@t-kashima
Last active March 27, 2017 06:53
Show Gist options
  • Save t-kashima/28e5924c12b66270ecc9b55479507548 to your computer and use it in GitHub Desktop.
Save t-kashima/28e5924c12b66270ecc9b55479507548 to your computer and use it in GitHub Desktop.
change database encoding to utf8mb4.
use [database_name];
alter database [database_name] character set utf8mb4;
alter database [database_name] collate utf8mb4_general_ci;
alter table [table_name] character set utf8mb4;
alter table [table_name] modify [collumn name] varchar(255) character set utf8mb4 not null;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment