티스토리 뷰

DATABASE

[MYSQL] characterset 변경

fallacy.kr 여우야뭐하니 2010.12.15 20:02

charset 확인

mysql> \s



[EUCKR]

mysql> SET character_set_client = euckr;
mysql> SET character_set_results = euckr;
mysql> SET character_set_connection = euckr;
mysql> ALTER DATABASE [DB명] DEFAULT CHARACTER SET euckr;
mysql> commit;

 

[UTF8]

mysql> SET character_set_client = utf8;
mysql> SET character_set_results = utf8;
mysql> SET character_set_connection = utf8;
mysql> ALTER DATABASE [DB명] DEFAULT CHARACTER SET utf8;
mysql> commit;

[출처] mysql charset 변경|작성자 아라한

댓글
댓글쓰기 폼