mysql> SELECT COLLATION_NAME FROM information_schema.columns WHERE table_name = 'notice' AND column_name = 'content'; +-----------------+ | COLLATION_NAME | +-----------------+ | utf8_general_ci | +-----------------+ 1 row in set (0.01 sec)