ALTER DATABASE `etracs254_bukidnon` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
SELECT CONCAT('ALTER TABLE ', TABLE_NAME, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;')
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'etracs254_bukidnon' AND TABLE_TYPE != 'VIEW';

SET FOREIGN_KEY_CHECKS = 0;
-- put result here
SET FOREIGN_KEY_CHECKS = 1;