NeMO84 · August 29, 2015 14:10
diff --git a/tables_collation_changer.sql b/tables_collation_changer.sql
 # Original: http://stackoverflow.com/questions/10859966/how-to-convert-all-tables-in-database-to-one-collation

 SELECT CONCAT("ALTER TABLE ", TABLE_NAME," COLLATE <COLLATION_VALUE>") AS    ExecuteTheString
 FROM INFORMATION_SCHEMA.TABLES
 WHERE TABLE_SCHEMA="<SCHEMA_NAME>"
 AND TABLE_TYPE="BASE TABLE";

 # Execute selected scripts.
	# Original: http://stackoverflow.com/questions/10859966/how-to-convert-all-tables-in-database-to-one-collation

	SELECT CONCAT("ALTER TABLE ", TABLE_NAME," COLLATE <COLLATION_VALUE>") AS ExecuteTheString
	FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_SCHEMA="<SCHEMA_NAME>"
	AND TABLE_TYPE="BASE TABLE";

	# Execute selected scripts.