[MySQL] mysql 캐릭터 셋 변경(utf8)

MySQL 캐릭터 셋 변경(utf8)

 

mysql> show variables like 'char%';

 

mysql> show table status from [데이터베이스명] like '테이블명';

 

vi /etc/my.cnf

 

[client]

default-character-set = utf8

 

[mysqld]

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