MySQL

(작성중) MySQL 한글깨짐현상

bang2001 2013. 12. 3. 12:45

#################################################

# Chatset Setting

#################################################

# [client]

# default-character-set=utf8

#

# [mysqld]

# character-set-server=utf8

# collation-server=utf8_general_ci

# init_connect=SET collation_connection=utf8_general_ci

# init_connect=SET NAMES utf8

#

# [mysql]

# default-character-set=utf8

#################################################


[client]

default-character-set=euckr


[mysqld]

character-set-server=euckr

collation-server=euckr_korean_ci

init_connect=SET collation_connection=euckr_korean_ci

init_connect=SET NAMES euckr


[mysql]

default-character-set=euckr



ALTER TABLE 테이블명 convert to charset euckr;

ALTER TABLE 테이블명 convert to charset utf8;