[mysql] character set 변경하기

mysql 설치된 경로에 

path\my.ini

default-character-set=Iatin1 => default-character=utf8

변경하고 재시작

database

alter database [databasename] charset=utf8

table 

alter table [tablename] charset=utf8

column

alter table [tablename]

change [exists_columnname] [new_columname] VARCHAR(10) CHARACTER SET utf8

확인

mysql> show variables like 'c%';