본문 바로가기
Database/MYSQL

SQL Yog euckr DB 연결했을때 한글등 깨질경우 처리

by 반화넬 2018. 7. 31.
반응형


mysql> SHOW GLOBAL VARIABLES LIKE '%character%'


mysql> SHOW SESSION VARIABLES LIKE '%character%'



SQL YOG 접속화면




# Advanced => Init command(s)에 입력함

SET SESSION character_set_client=utf8;SET SESSION character_set_connection=utf8;SET SESSION character_set_database=euckr;SET SESSION character_set_results=utf8;SET SESSION character_set_server=euckr;



반응형