전체 database character set 확인
mysql> SELECT SCHEMA_NAME AS 'database', DEFAULT_CHARACTER_SET_NAME AS 'character_set', DEFAULT_COLLATION_NAME AS 'collation'
FROM information_schema.SCHEMATA;
|
하나의 database character set 확인
mysql> USE database_name;
mysql> SHOW VARIABLES LIKE 'character_set_database';
|
table collation 확인
mysql> SHOW TABLE STATUS WHERE NAME LIKE 'table_name';
|
column collation 확인
mysql> SHOW FULL COLUMNS FROM table_name;
|
Ref : https://stackoverflow.com/questions/1049728/how-do-i-see-what-character-set-a-mysql-database-table-column-is