리눅스 쉘 MySQL UTF8

1 문제상황

[root@zetawiki ~]# mysql -u dbuser -pP@ssw0rd zetadb
... (생략)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select id,worker,state from job;
+----+--------+-------+
| id | worker | state |
+----+--------+-------+
| 17 | ???    | ??    |
| 23 | ???    | ??    |
| 21 | ???    | ??    |
+----+--------+-------+

2 해결방법 1

mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> select id,worker,state from job;
+----+--------+-------+
| id | worker | state |
+----+--------+-------+
| 17 | 한놈   | 완료  |
| 23 | 두시기 | 완료  |
| 21 | 석삼   | 취소  |
+----+--------+-------+

3 해결방법 2

[root@zetawiki ~]# mysql -u dbuser -pP@ssw0rd zetadb --default-character-set=utf8
... (생략)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select id,worker,state from job;
+----+--------+-------+
| id | worker | state |
+----+--------+-------+
| 17 | 한놈   | 완료  |
| 23 | 두시기 | 완료  |
| 21 | 석삼   | 취소  |
+----+--------+-------+

4 같이 보기

• /usr/bin/mysql

5 참고

• http://stackoverflow.com/questions/6787824/mysql-command-line-formatting-with-utf8
• http://makandracards.com/makandra/7433-mysql-shell-enable-utf-8