mysql 4.1 이상 + 한글 윈도우 CMD에서 접속 할 경우 언어셋 문제.

--------------------------------------------------------------=--------

• mv7_bmaster 는 utf-8로 되어있음.

• 윈도우 CHCP는 CHCP 949
• mysql> show variables like 'char%';
  +--------------------------+-----------------------------------------+
  | 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                                    |
  | character_sets_dir       | C:\AutoSet\Server\mysql\share\charsets\ |
  +--------------------------+-----------------------------------------+
• mysql> select * from mv7_bmaster;
  +------+-----------+----------+----------------+----------------+---------+----------+
  | b_id | bm_table  | bm_title | bm_dttm_w      | bm_dttm_e      | bm_skin | bm_limit |
  +------+-----------+----------+----------------+----------------+---------+----------+
  |      | NULL      | NULL     | NULL           | NULL           | NULL    |       10 |
  | test | mv7b_test | ???      | 20090417210000 | 20090417210000 | default |       10 |
  +------+-----------+----------+----------------+----------------+---------+----------+
  2 rows in set (0.01 sec)
• mysql> SET NAMES UTF8;
• mysql> show variables like '%char%';
  +--------------------------+-----------------------------------------+
  | Variable_name            | Value                                   |
  +--------------------------+-----------------------------------------+
  | character_set_client     | utf8                                    |
  | character_set_connection | utf8                                    |
  | character_set_database   | utf8                                    |
  | character_set_filesystem | binary                                  |
  | character_set_results    | utf8                                    |
  | character_set_server     | utf8                                    |
  | character_set_system     | utf8                                    |
  | character_sets_dir       | C:\AutoSet\Server\mysql\share\charsets\ |
  +--------------------------+-----------------------------------------+
• mysql> select * from mv7_bmaster;
  +------+-----------+-----------+----------------+----------------+---------+----------+
  | b_id | bm_table  | bm_title  | bm_dttm_w      | bm_dttm_e      | bm_skin | bm_limit |
  +------+-----------+-----------+----------------+----------------+---------+----------+
  |      | NULL      | NULL      | NULL           | NULL           | NULL    |       10 |
  | test | mv7b_test | ?뚯뒪??| 20090417210000 | 20090417210000 | default |       10 |
  +------+-----------+-----------+----------------+----------------+---------+----------+
• mysql> SET NAMES EUCKR;
• mysql> show variables like '%char%';
  +--------------------------+-----------------------------------------+
  | Variable_name            | Value                                   |
  +--------------------------+-----------------------------------------+
  | character_set_client     | euckr                                   |
  | character_set_connection | euckr                                   |
  | character_set_database   | utf8                                    |
  | character_set_filesystem | binary                                  |
  | character_set_results    | euckr                                   |
  | character_set_server     | utf8                                    |
  | character_set_system     | utf8                                    |
  | character_sets_dir       | C:\AutoSet\Server\mysql\share\charsets\ |
  +--------------------------+-----------------------------------------+
• mysql> select * from mv7_bmaster;
  +------+-----------+----------+----------------+----------------+---------+----------+
  | b_id | bm_table  | bm_title | bm_dttm_w      | bm_dttm_e      | bm_skin | bm_limit |
  +------+-----------+----------+----------------+----------------+---------+----------+
  |      | NULL      | NULL     | NULL           | NULL           | NULL    |       10 |
  | test | mv7b_test | 테스트   | 20090417210000 | 20090417210000 | default |       10 |
  +------+-----------+----------+----------------+----------------+---------+----------+

• 결론
  • 괜히 UTF-8이라고 임의로 UTF-8로 설정해봤자 피본다.
  • 접속콘솔이 EUC-KR일 경우 MySQL 쪽을 EUC-KR로 맞추면 된다.