Server/MariaDB & MySQL

우분투 MySQL Character set 설정 (default encoding) UTF8로 바꾸기

DrumRobot 2020. 4. 19. 02:55
반응형

vi /etc/mysql/conf.d/charset.cnf

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
skip-character-set-client-handshake
init_connect="SET collation_connection = utf8mb4_unicode_ci"
init_connect="SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysqldump]
default-character-set = utf8mb4

 

반응형