#!/bin/bash

DATABASE="myDatabase"
CHARSET="utf8"
COLLATE="utf8_general_ci"

IFS=$'\n'
QUERY="SELECT CONCAT('ALTER TABLE \`$DATABASE\`.\`', TABLE_NAME,'\` CONVERT TO CHARACTER SET $CHARSET COLLATE $COLLATE;') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$DATABASE' AND TABLE_TYPE='BASE TABLE' AND TABLE_COLLATION!='$COLLATE'"

for MYSQL_CMD in `mysql -B -e "$QUERY"`; do
  echo "$MYSQL_CMD"
  mysql -B -e "$MYSQL_CMD"
done