package tools.wztosql;
import database.DatabaseConnection;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class FixCharSets {
public static void main(String[] args) {
Connection con = DatabaseConnection.getConnection();
try {
try (ResultSet rs = con.prepareStatement("SELECT CONCAT('ALTER TABLE `', tbl.`TABLE_SCHEMA`, '`.`', tbl.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') FROM `information_schema`.`TABLES` tbl WHERE tbl.`TABLE_SCHEMA` = 'astralms'").executeQuery()) {
PreparedStatement ps;
while (rs.next()) {
System.out.println(rs.getString(1));
try {
ps = con.prepareStatement(rs.getString(1));
ps.execute();
ps.close();
} catch (SQLException ex) {
}
}
}
} catch (SQLException ex) {
}
}
}