MySQL 접속 후 status 값을 보면
mysql> status
--------------
mysql Ver 14.14 Distrib 5.1.41, for pc-linux-gnu (i686) using EditLine wrapper
Connection id: 2
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.41-debug-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: euckr
Server characterset: euckr
UNIX socket: /tmp/mysql.sock
Uptime: 2 min 10 sec
이렇게 나옵니다.
이중 characterset 값을 보면
DB characterset:
Conn characterset: 값이 나오지 않습니다. 이 두개 의 값을 설정하여 status에 표출되게 하려면 어떻게 해야 되나요?
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 | /usr/local/mysql/share/mysql/charsets/ |
| collation_connection | euckr_korean_ci |
| collation_database | euckr_korean_ci |
| collation_server | euckr_korean_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 10 |
+--------------------------+----------------------------------------+
|