글쓴이: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>