MySQL Character Set Config

my.cnf 파일 수정

[client]
default-character-set = utf8


[mysqld]
character-set-client-handshake=FALSE
init_connect=”SET collation_connection = utf8_general_ci”
init_connect=”SET NAMES utf8″
default-character-set = utf8
character-set-server = utf8
collation-server = utf8_general_ci


[mysqldump]
default-character-set = utf8


[mysql]
default-character-set = utf8


MySQL 콘솔에서 “\s“명령으로 설정 확인 가능

댓글 남기기

This site uses Akismet to reduce spam. Learn how your comment data is processed.