SELECT `COLLATION_NAME` FROM `information_schema` . `columns` WHERE `COLLATION_NAME` IS NOT NULL AND `table_schema` = ? AND `table_name` IN (...) UNION SELECT `TABLE_COLLATION` FROM `information_schema` . `tables` WHERE `TABLE_COLLATION` IS NOT NULL AND `table_schema` = ? AND `table_name` IN (...) 