gistfile1.txt

mysql> SELECT character_set_name, column_name FROM information_schema.`COLUMNS` C
    -> WHERE table_schema = "sg_authoring_pro"
    ->   AND table_name = "units";
+--------------------+--------------+
| character_set_name | column_name  |
+--------------------+--------------+
| NULL               | id           |
| utf8               | name         |
| utf8               | abbreviation |
| NULL               | created_at   |
| NULL               | updated_at   |
+--------------------+--------------+