mysql charecter set 설정 (DB 글자깨짐)
한글 등록시 글자 깨질때 DB의 character set을 확인해 보자. 1. 확인1) SHOW CHARACTER SET; 2) DB 확인SELECT default_character_set_name FROM information_schema.SCHEMATA SWHERE schema_name = "[DB명]"; 3) Table 확인SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSAWHERE CCSA.collation_name = T.table_collation AND T.table_schema = "[DB명]" AND T.ta..