mysql character set 설정 문제
글쓴이: purenous / 작성시간: 화, 2012/12/04 - 10:38오전
안녕하세요.
mantis 한글지원때문에 mysql 문자셋을 euckr로 설정하려고 하는데요.
my.cnf에 아래 항목을 추가 후 restart한 후 status를 보면
Server와 Db characterset이 latin1으로 유지되는 게 문제입니다.
[client]
default-character-set = euckr
[mysqld]
default-character-set = euckr
character-set-server = euckr
character-set-database = euckr
character-set-client-handshake = FALSE
language = /usr/share/mysql/korean
[mysql-dump]
default-character-set = euckr
default-character-set = euckr mysql> status -------------- mysql Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (i486) using readline 6.1 Connection id: 36 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.1.66-0ubuntu0.10.04.1 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: euckr Conn. characterset: euckr UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 33 min 39 sec
Forums:
아래처럼 직접 명령해서 세팅하면 제대로 세팅이 되긴
아래처럼 직접 명령해서 세팅하면 제대로 세팅이 되긴 하는데
나갔다 들어오면 다시 Server 와 Db characterset이 latin1으로 돌아오네요.
mysql> SET character_set_server=euckr;
Query OK, 0 rows affected (0.00 sec)
mysql> SET character_set_database=euckr;
Query OK, 0 rows affected (0.00 sec)
mysql> status
--------------
mysql Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (i486) using readline 6.1
Connection id: 37
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.66-0ubuntu0.10.04.1 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: euckr
Db characterset: euckr
Client characterset: euckr
Conn. characterset: euckr
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 1 hour 1 min 26 sec