Database
[mysql]euckr에서 uft8로 변경 방법
애플자라
2007. 8. 30. 00:10
반응형
* euckr에서 uft8로 변경 방법
mysql>SET character_set_client = utf8;
mysql>SET character_set_results = utf8;
mysql>SET character_set_connection = utf8;
mysql>ALTER DATABASE ems50 DEFAULT CHARACTER SET utf8;
commit;
반대로 * uft8에서 euckr로 변경 방법
SET character_set_client = euckr;
SET character_set_results = euckr;
SET character_set_connection = euckr;
ALTER DATABASE EMS51 DEFAULT CHARACTER SET euckr;
commit;
status로 확인
mysql>SET character_set_client = utf8;
mysql>SET character_set_results = utf8;
mysql>SET character_set_connection = utf8;
mysql>ALTER DATABASE ems50 DEFAULT CHARACTER SET utf8;
commit;
반대로 * uft8에서 euckr로 변경 방법
SET character_set_client = euckr;
SET character_set_results = euckr;
SET character_set_connection = euckr;
ALTER DATABASE EMS51 DEFAULT CHARACTER SET euckr;
commit;
status로 확인
반응형