현재 캐릭터셋 확인하기
mysql> show variables like 'c%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 10 |
+--------------------------+----------------------------------------+
14 rows in set (0.00 sec)
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (x86_64) using readline 5.1
Connection id: 73
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.67-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 15 hours 27 min 55 sec
Threads: 1 Questions: 791 Slow queries: 0 Opens: 39 Flush tables: 1 Open tables: 34 Queries per second avg: 0.014
--------------
이런식으로 뜬다.
변경하기
vi /etc/my.cnf
[client]
default-character-set=euckr
[mysqld]
default-character-set=euckr
init_connect=SET collation_connection=euckr_korean_ci
init_connect=SET NAMES euckr
character-set-server=euckr
collation-server=euckr_korean_ci
[mysqldump]
default-character-set=euckr
[mysql]
default-character-set=euckr
euckr 및 euckr_korean_ci 를 원하는 해당 캐릭터셋으로 바꾸어주면 된다.
추가 및 변경 후, MySQL 을 재시작 해주어야 적용된다.
service mysqld restart