[MySQL] `utf8` or `euckr` charset 설정

Posted at 2007/06/30 10:46 // in 데이터베이스™/MySQL // by 블루비
/etc.my.cnf 파일을 얼어 아래의 charset 에 맞게 셋팅 후 mysql 을 재실행한다.

---------------------- utf8 ---------------------------

[mysqld]
init_connect=SET collation_connection=utf8_general_ci
init_connect=SET NAMES utf8
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci



---------------------- euckr ---------------------------
[mysqld]
init_connect=SET collation_connection=euckr_korean_ci
init_connect=SET NAMES euckr
default-character-set=euckr
character-set-server=euckr
collation-server=euckr_korean_ci



--------------------------------------------------------

# killall mysqld
# /usr/bin/mysqld_safe&

2007/06/30 10:46 2007/06/30 10:46

http://blueb.net/blog/trackback/892

댓글을 남겨주세요.

[로그인][오픈아이디란?]