글쓴이:pardner utf8 설정 - 웹, DB콘솔 모두 가능하네요 ^^ 조회수:9


많은 분들의 의견과...정리해주신 알짜초보님의 글을 참고로...
UTF-8 설정시 MySQL 콘솔(DB 내용) 작업시 문제점만 해결해 봤습니다.

1) 문제점

mysql> show variables like 'c%';
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | W:\mysql\share\charsets/ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 5 |
+--------------------------+--------------------------+
13 rows in set (0.01 sec)

mysql> create table utf_euc (var_k varchar(100), var_e varchar(100));
Query OK, 0 rows affected (0.19 sec)

mysql> insert into utf_euc set var_k="한글로 넣을꺼야", var_e="this is english variable ";
ERROR 1406 (22001): Data too long for column 'var_k' at row 1

2) 설정 변경

mysql> set character set euckr;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'c%';
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | euckr |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | euckr |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | W:\mysql\share\charsets/ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 5 |
+--------------------------+--------------------------+
13 rows in set (0.00 sec)

mysql> insert into utf_euc set var_k="한글로 넣을꺼야", var_e="this is english v
field";
Query OK, 1 row affected (0.05 sec)

mysql> select * from utf_euc;
+-----------------+------------------------+
| var_k | var_e |
+-----------------+------------------------+
| 한글로 넣을꺼야 | this is english vfield |
+-----------------+------------------------+
1 row in set (0.00 sec)

3) 웹(utf8)에서 2번째꺼 삽입된 결과 확인

mysql> select * from utf_euc;
+-----------------+------------------------+
| var_k | var_e |
+-----------------+------------------------+
| 한글로 넣을꺼야 | this is english vfield |
| 이거도 한글^^ | 이거는 영언데 ㅠㅠ |
+-----------------+------------------------+
2 rows in set (0.01 sec)

3) 참고

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

mysql> select * from utf_euc;
+------------------------+----------------------------+
| var_k | var_e |
+------------------------+----------------------------+
| ?ㅤㅆㅝㅅ?濡??ｌㅤㅆㅠㅀ爰쇱ㅤㅂㅣㅍ | this is english vfield |
| ?닿굅???ㅤㅆㅝㅅ?^^ | ?닿굅???ㅤㄱㅗㅋㅤㅃㅖㅂ???ㅤㅈㅗㄽㅤㄲㅠㄲ |
+------------------------+----------------------------+
2 rows in set (0.00 sec)

mysql>