Skip to content

Instantly share code, notes, and snippets.

@mmqmzk
Last active March 28, 2020 07:20
Show Gist options
  • Save mmqmzk/eeda0ec93341971eba43f9cba1dfc35d to your computer and use it in GitHub Desktop.
Save mmqmzk/eeda0ec93341971eba43f9cba1dfc35d to your computer and use it in GitHub Desktop.
Mysql & MariaDB use utf8mb4 as default.
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
innodb_large_prefix = true
innodb_file_format = barracuda
innodb_file_per_table = 1
init_connect='SET NAMES utf8mb4'
character-set-client-handshake = FALSE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment