뒤늦게 한글 인코딩에 관해 질문합니다.

rchung@rchung-Inspiron-1521:~/kmcc$ file backup.sql
backup.sql: UTF-8 Unicode text, with very long lines

mysql> select nick_name from jj_member where member_srl in (4,183);
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    16901691
Current database: kmcckmcc_db2
 
+-----------+
| nick_name |
+-----------+
| ??        |  // 이게 user 입장에서는 잘 저장된 형태입니다.
| ??? ??    |
+-----------+
2 rows in set (0.00 sec)
 
 
mysql> select nick_name from jj_member_test2 where member_srl = 4;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    16958042
Current database: kmcckmcc_db2
 
+-----------+
| nick_name |
+-----------+
| 웹팀    |    // 이 데이타는 유저의 브라우저에서,  'ê°•ê°•ê°•' 이런 식으로 보입니다.  
+-----------+
1 row in set (0.00 sec)

mysql> show variables like 'character\_set\_%';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_client     | latin1 |
| character_set_connection | latin1 |
| character_set_database   | utf8   |
| character_set_filesystem | binary |
| character_set_results    | latin1 |
| character_set_server     | utf8   |
| character_set_system     | utf8   |
+--------------------------+--------+
7 rows in set (0.00 sec)

mysql> show create table jj_member;
 
| jj_member | CREATE TABLE `jj_member` (
 `member_srl` bigint(11) NOT NULL,
 `user_id` varchar(80) NOT NULL,
 `email_address` varchar(250) NOT NULL,
 `password` varchar(60) NOT NULL,
 `email_id` varchar(80) NOT NULL,
 `email_host` varchar(160) DEFAULT NULL,
 `user_name` varchar(40) NOT NULL,
 `nick_name` varchar(40) NOT NULL,
 `homepage` varchar(250) DEFAULT NULL,
 `blog` varchar(250) DEFAULT NULL,
 `birthday` char(8) DEFAULT NULL,
 `allow_mailing` char(1) NOT NULL DEFAULT 'Y',
 `allow_message` char(1) NOT NULL DEFAULT 'Y',
 `denied` char(1) DEFAULT 'N',
 `limit_date` varchar(14) DEFAULT NULL,
 `regdate` varchar(14) DEFAULT NULL,
 `last_login` varchar(14) DEFAULT NULL,
 `is_admin` char(1) DEFAULT 'N',
 `description` text,
 `extra_vars` text,
 `change_password_date` varchar(14) DEFAULT NULL,
 `find_account_question` bigint(11) DEFAULT NULL,
 `find_account_answer` varchar(250) DEFAULT NULL,
 `list_order` bigint(11) DEFAULT NULL,
 PRIMARY KEY (`member_srl`),
 UNIQUE KEY `unique_user_id` (`user_id`),
 UNIQUE KEY `unique_email_address` (`email_address`),
 UNIQUE KEY `unique_nick_name` (`nick_name`),
 KEY `idx_email_host` (`email_host`),
 KEY `idx_allow_mailing` (`allow_mailing`),
 KEY `idx_is_denied` (`denied`),
 KEY `idx_regdate` (`regdate`),
 KEY `idx_last_login` (`last_login`),
 KEY `idx_is_admin` (`is_admin`),
 KEY `idx_list_order` (`list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |