[root@zetawiki ~]# mysql -uroot -pP@ssw0rd mydb
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4828
... (생략)
mysql> SELECT * FROM department;
+----+------+
| id | name |
+----+------+
| 1 | ??? |
| 2 | ??? |
+----+------+
2 rows in set (0.00 sec)
mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> quit
Bye
[root@zetawiki ~]# vi /etc/my.cnf
[client]
default-character-set=utf8
[root@zetawiki ~]# mysql -uroot -pP@ssw0rd mydb
Welcome to the MySQL monitor. Commands end with ; or \g.
... (생략)
mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> SELECT * FROM department;
+----+-----------+
| id | name |
+----+-----------+
| 1 | 영업팀 |
| 2 | 개발팀 |
+----+-----------+
2 rows in set (0.00 sec)