MYSQL charset 확인방법 및 변경

mysql> show variables like '%char%';

 

[EUCKR]

mysql> SET character_set_client = euckr;
mysql> SET character_set_results = euckr;
mysql> SET character_set_connection = euckr;

mysql> SET character_set_database = euckr;

mysql> SET character_set_filesystem = euckr;

mysql> SET character_set_server = euckr;
mysql> ALTER DATABASE [DB명] DEFAULT CHARACTER SET euckr;
mysql> commit;