mysql euckr 설정

<설정>
# vi /etc/my.cnf (windows : [MYSQL_PATH]/my.ini 편집)
[client]
default-character-set=euckr

[mysqld]
language=[MYSQL_PATH]/share/korean
init_connect = SET collation_connection=euckr
init_connect = SET NAMES euckr
default-character-set=euckr
collation-server=euckr
default-collation=euckr_korean_ci

[mysqldump]
default-character-set=euckr

[mysql]
default-character-set=euckr

# service mysqld restart


<확인>
mysql> show variables like 'c%';
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | euckr                    |
| character_set_connection | euckr                    |
| character_set_database   | euckr                    |
| character_set_filesystem | binary                   |
| character_set_results    | euckr                    |
| character_set_server     | euckr                    |
| character_set_system     | utf8                     |
| character_sets_dir       | C:\MySQL\share\charsets\ |
| collation_connection     | euckr_korean_ci          |
| collation_database       | euckr_korean_ci          |
| collation_server         | euckr_korean_ci          |
| completion_type          | 0                        |
| concurrent_insert        | 1                        |
| connect_timeout          | 5                        |
+--------------------------+--------------------------+
14 rows in set (0.00 sec)