[MySQL] Changing character encoding

1. 설정파일 변경

# vi /etc/my.cnf

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake 

위에 있는 세가지 옵션을 추가 또는 변경한다.

2. 확인

# mysql -u root -p
mysql> show variables like 'c%';

character_set_client : utf8

character_set_connection : utf8

character_set_database : utf8

character_set_results : utf8

character_set_server : utf8

character_set_system : utf8

character_sets_dir : /usr/share/mysql/charsets/

collation_connection : utf8_general_ci

collation_database : utf8_general_ci

collation_server : utf8_general_ci

이렇게 변경된 것을 확인할 수 있다.


Reference 

http://kldp.org/node/99186