많은 분들의 의견과...정리해주신 알짜초보님의 글을 참고로...
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>

요넘 때문에 무지 고생했네요...

많은 분들의 의견과...정리해주신 알짜초보님의 글을 참고로...

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>



요넘 때문에 무지 고생했네요...