Something

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)