mysql> 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 = "cald"
    ->   AND T.table_name = "webform_submitted_data";
+--------------------+
| character_set_name |
+--------------------+
| utf8               |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT character_set_name FROM information_schema.`COLUMNS` C
    -> WHERE table_schema = "cald"
    ->   AND table_name = "webform_submitted_data"
    ->   AND column_name = "data";
+--------------------+
| character_set_name |
+--------------------+
| utf8               |
+--------------------+
1 row in set (0.01 sec)

mysql> 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 = "cald"
    ->   AND T.table_name = "webform_submissions";
+--------------------+
| character_set_name |
+--------------------+
| utf8               |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT character_set_name FROM information_schema.`COLUMNS` C
    -> WHERE table_schema = "cald"
    ->   AND table_name = "webform_submissions"
    ->   AND column_name = "data";
Empty set (0.00 sec)

mysql> 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 = "cald"
    ->   AND T.table_name = "webform_component";
+--------------------+
| character_set_name |
+--------------------+
| utf8               |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT character_set_name FROM information_schema.`COLUMNS` C
    -> WHERE table_schema = "cald"
    ->   AND table_name = "webform_component"
    ->   AND column_name = "data";
Empty set (0.00 sec)

mysql>