mySQL 전역 설정 변경
2013-05-08이상하게 utf8으로 바꾸는데 안 바뀌어서, session과 global 양 쪽을 다 바꾸었다.
SET GLOBAL character_set_client = “utf8”, character_set_connection = “utf8”, character_set_database = “utf8”, character_set_results = “utf8” , character_set_server = “utf8”, collation_connection = “utf8_general_ci”, collation_server = “utf8_general_ci”;
SET SESSION character_set_client = “utf8”, character_set_connection = “utf8”, character_set_database = “utf8”, character_set_results = “utf8” , character_set_server = “utf8”, collation_connection = “utf8_general_ci”, collation_server = “utf8_general_ci”;
이유를 모르니 찜찜하지만… 여튼 해결. 그런데 콘솔에서 접근하면 collation_connection은 여전히 latin1_swedish_ci 으로 뜬다… 뭐지…