본문 바로가기

DATABASE

[MYSQL] characterset 변경

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 변경|작성자 아라한