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로 맞추면 된다.