Skip to content

Instantly share code, notes, and snippets.

@nondanee
Last active November 8, 2018 07:08
Show Gist options
  • Save nondanee/60c3126df7378634b59c8520167a25ed to your computer and use it in GitHub Desktop.
Save nondanee/60c3126df7378634b59c8520167a25ed to your computer and use it in GitHub Desktop.
MySQL use utf8mb4 character set
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect = 'SET NAMES utf8mb4'
# SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';
@nondanee
Copy link
Author

nondanee commented Nov 8, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment