Skip to content

Instantly share code, notes, and snippets.

@t-kashima

t-kashima/change_encoding.sql

Last active March 27, 2017 06:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • 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.
Download ZIP
change database encoding to utf8mb4.
Raw
change_encoding.sql
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