Mysql캐릭터셋확인 및 변경

* 캐릭터셋 확인

#database 확인
SELECT default_character_set_name FROM information_schema.SCHEMATA S
WHERE schema_name = "mydb";

#table 확인
SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,
       information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
WHERE CCSA.collation_name = T.table_collation
  AND T.table_schema = "mydb"
  AND T.table_name = "mytable";


#column 확인
SELECT character_set_name FROM information_schema.`COLUMNS` C
WHERE table_schema = "mydb"
  AND table_name = "mytable"
  AND column_name = "mycolumn";

#Show 명령어 사용(추천)
SHOW FULL COLUMNS FROM mytable;

*캐릭터셋 변경

#데이터베이스 디폴트 캐릭터셋 변경
alter database [dbname] DEFAULT CHARACTER set utf8;

#utf-8일때는 utf8 , utf8_general_ci
ALTER TABLE 테이블명 MODIFY COLUMN 컬럼 VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci

#euc-kr일때는 euckr , euckr_korean_ci
ALTER TABLE 테이블명 MODIFY COLUMN 컬럼 VARCHAR(255) CHARACTER SET euckr COLLATE euckr_general_ci


#테이블의 모든 컬럼의 charset 를 변경할 경우
alter table 테이블명 convert to character set utf8;
alter table 테이블명 convert to character set euckr;